python连接数据库进行操作

import pymysql
from pprint import pprint
db=pymysql.connect("localhost","root","密码","test",charset="utf8")
cursor=db.cursor()
sql='create table student(name varchar(20),id int,sex char(20)) default charset=utf8'
sql='insert into student values("张三",20,"男")'
sql='insert into student values("李四",25,"男")'
cursor.execute(sql)
db.commit()
db.close()

获取信息：fetchone fetchmany fetchall
for i in (cursor.rowcount):
pprint(cursor.fetchone())