mysql 表名设置为参数的多参数SQL语句怎么写?

Question

比如这个句子sql = "SELECT NAME from %swhere id =%s" %(tablename,id)获取id为某值的某表的字段名，这样写是报错的，要怎么写才行？

Answer 1

sql = "SELECT NAME from %s where id ='%d'" % (tablename, 1)

希望对你有帮助