python连接db2数据库报错_Python连接mysql数据库报错

importpymysql.cursorsconnection=pymysql.connect(host='localhost',port=3306,user='root',password='123456',db='test',charset='utf8mb4')cur=connection.cursor()sql="insertint...

import pymysql.cursors

connection = pymysql.connect(

host='localhost',

port=3306,

user='root',

password='123456',

db='test',

charset='utf8mb4'

)

cur = connection.cursor()

sql = "insert into test(id,username,userpassword) values(%s,'%s','%s')"

# date = (5,'fffff','fffff')

cur.execute(sql, (5, 'fffff', 'fffff'))

connection.commit()

connection.close()

错误

C:\Python34\python.exe E:/pycode/test/test

Traceback (most