>>> column_names = ["first_name", "last_name", "email"] # sample data
>>> column_string = ",".join(f"[{x}]" for x in column_names)
>>> column_string
'[first_name],[last_name],[email]'
>>> sql = f"SELECT {column_string} FROM [tablename] WHERE ..."
>>> sql
'SELECT [first_name],[last_name],[email] FROM [tablename] WHERE ...'
。。。或者,为了在列名可能包含右方括号的情况下更加健壮:
>>> column_names = ["start time", "duration [minutes]"]
>>> column_string = ",".join(f"[{x.replace(']',']]')}]" for x in column_names)
>>> column_string
'[start time],[duration [minutes]]]'
您可以使用
join
构建一个逗号分隔的列名字符串,然后将其格式化到SQL语句中:。。。或者,为了在列名可能包含右方括号的情况下更加健壮:
相关问题 更多 >
编程相关推荐