使用格式化输出自动扩展Python列表

Does anyone know if there's a way to automatically expand a list in Python, separated by commas? I'm writing some Python code that uses the MySQLdb library, and I'm trying to dynamically update a list of rows in a MySQL database with certain key values.

有没有人知道是否有一种方法可以自动扩展Python中的列表,用逗号分隔?我正在编写一些使用MySQLdb库的Python代码,我正在尝试使用某些键值动态更新MySQL数据库中的行列表。

For instance, in the code below, I'd like to have the numeric values in the record_ids list expand into a SQL "IN" clause.

例如,在下面的代码中,我想让record_ids列表中的数值扩展为SQL“IN”子句。

import MySQLdb
record_ids = [ 23, 43, 71, 102, 121, 241 ]

mysql = MySQLdb.connect(user="username", passwd="secret", db="apps")
mysql_cursor = mysql.cursor()

sqlStmt="UPDATE apps.sometable SET lastmod=SYSDATE() where rec_id in ( %s )"

mysql_cursor.execute( sqlStmt, record_ids )
mysql.commit()

Any help would be appreciated!

任何帮助,将不胜感激!

5 个解决方案

#1

try:

",".join( map(str, record_ids) )

",".join( list_of_strings ) joins a list of string by separating them with commas

“,”。join(list_of_strings)通过用逗号分隔它们来连接字符串列表

if you have a list of numbers, map( str, list ) will convert it to a list of strings

如果您有一个数字列表,map(str,list)会将其转换为字符串列表

5 个解决方案

#1

更多相关文章

随机推荐