pymysql 入库 %s 占位符问题

This topic created in 2821 days ago, the information mentioned may be changed or developed.

sql = "INSERT INTO %s (%s) VALUES (%s)" val=(table, fields[:-1], values[:-1]) cursor.execute(sql, val) 我这边这么格式化参数对的.但是入库时报错 1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 请问是什么情况

SQL

val

syntax

values

2 replies • 2018-08-21 13:59:37 +08:00

sujin190

Aug 21, 2018

你把一个数组直接转成字符串扔给 mysql 运行肯定挂啊

blankme

Aug 21, 2018

table name 不能直接作为变量传入
psycopg2 的相关说明： http://initd.org/psycopg/docs/sql.html
pymysql 应该也有相应的处理方式