#coding=utf-8
import MySQLdb
import MySQLdb.cursors

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