Python MySQLdb

#-*- coding:utf-8 -*-'''Created on 2017年9月6日@author: Administrator'''import MySQLdbconn=MySQLdb.connect(host="localhost",user="root",passwd="root",db="mydb",charset="utf8")# sql = "create table Person(id int primary key auto_increment,name char(255),age int,address char(255),);"cursor = conn.cursor()# sql ="insert into Person(id,name,age,address) values(3,'wangwu',13,'hangzhou');"# # param = ("Lisi","Beijing")# n = cursor.execute("insert into Person(id,name,age,address) values(4,'wangwu',13,'hangzhou');")# print n# n = cursor.execute("select * from Person;")    # for row in cursor.fetchall():    #     for r in row:    #         print r    try:    n = cursor.execute("insert into Person(id,name,age,address) values(5,'wangwu',13,'hangzhou');")    print n    # 这个一定要写    conn.commit()except:    conn.rollback()cursor.close() conn.close()