如何在python中以更美观的方式构建mysql查询字符串？

table_name = 'users'
query = 'SELECT * FROM ' + table_name + ' WHERE age > 18'
print(query)

SELECT * FROM users WHERE age > 18

table_name = 'users'
min_age = 18
query = f'SELECT * FROM {table_name} WHERE age > {min_age}'
print(query)

SELECT * FROM users WHERE age > 18

import mysql.connector

table_name = 'users'
min_age = 18

# 创建连接
cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='database_name')
cursor = cnx.cursor()

# 使用占位符构建查询字符串
query = 'SELECT * FROM {} WHERE age > %s'.format(table_name)

# 执行查询
cursor.execute(query, (min_age,))

# 处理查询结果
for result in cursor:
    print(result)

# 关闭连接
cursor.close()
cnx.close()