python 操作mysql
#encoding=utf-8
from mysql import connector
from __future__ import print_function
sql = 'create table student(name char(20),age char(20))'
sqltmp = 'INSERT INTO `student` (`name`,`age`) VALUES (%s, %s)'
values = [("你的名字","23")]
cnx = connector.connect(host="127.0.0.1", user="root", password="", database="mydb", charset="utf8")
cnx.autocommit = True
db0 = cnx.cursor()
#db0.execute(sql)
db0.executemany(sqltmp,values)
for row in db0:
print (row)
注意:values是一个列表