Python MySQLdb

#-*- coding:utf-8 -*-
'''
Created on 2017年9月6日

@author: Administrator
'''

import MySQLdb

conn=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()