python 操作MySQL

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是一个列表