mysql pymysql遇到问题

Lk895146260

import pymysql

db = pymysql.connect(
    host = 'localhost',
    user = '***',
    password = '***',
    port = 3306,
    db = "s"
    )
sql = 'SELECT * FROM teacher WHERE age >= 18'
cursor = db.cursor()
data = {
    'id ': '201212001',
    'user' : 'Bob',
    'age' : 65
}
table = 'teacher'
keys = ','.join(data.keys())
values = ','.join(['%s'] * len(data))
sql = 'INSERT INTO {table}({keys}) VALUES ({values})'.format(table = table,keys = keys, values = values)
if cursor.execute(sql,tuple(data.values())):
    print("Successful")
    db.commit()

错误：pymysql.err.InternalError: (1054, "Unknown column 'user' in 'field list'")

在使用pymysql时插入不进去数据  总是报错 麻烦大佬帮忙指点 万分感谢。

zltzlt

这一句：

1. sql = 'INSERT INTO {table}({keys}) VALUES ({values})'.format(table = table,keys = keys, values = values)

复制代码

改成这样试试：

1. sql = 'INSERT INTO teacher(id,user,age) VALUES (%s,%s,%s)' % ('201212001', 'Bob', '65')

复制代码