python中mysql基本使用

整理自己走过的新手路程

import pymysql

#print(pymysql.__version__)
conn = pymysql.connect(host='localhost',port=3306,user='root',passwd='5ai0x3s',db='pythonai_db')

cur = conn.cursor()
'''创建表'''
'''createsql = "create table pytable(name char(10),sex char(4),age int)"

cur.execute(createsql)

cur.close()'''
'''向表中插入数据'''
insertsql = "INSERT INTO pytable(name,sex,age) VALUES('%s,','%c','%d')"%('bob','F',20)

cur.execute(insertsql)

conn.commit()

#cur.close()

#conn.close()
'''查询数据'''
selectsql = "select*from pytable "

cur.execute(selectsql)

data = cur.fetchall()

for r in data:

	print(r)

cur.close()