Python操作MySQL数据库

#coding=utf-8import MySQLdbimport MySQLdb.cursorsconn= MySQLdb.connect(        host='localhost',        port = 3306,        user='root',        passwd='root',        db ='test',        cursorclass = MySQLdb.cursors.DictCursor, charset='utf8')cur = conn.cursor()#创建数据表#cur.execute("create table student(id int ,name varchar(20),class varchar(30),age varchar(10))")#插入一条数据#cur.execute("insert into student values('2','Tom','3 year 2 class','9')")#修改查询条件的数据#cur.execute("update student set class='3 year 1 class' where name = 'Tom'")#删除查询条件的数据#cur.execute("delete from student where age='9'")cur.execute('select name from student')for data in cur.fetchall():    print data['name']    conn.commit()cur.close()conn.close()