pymysql简单使用记忆

import pymysql
conn = pymysql.connect(host='127.0.0.1',user='root',database='day61',passwd='123',port=3306,charset='utf8')
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)#查出来数据是字典格式
#操作 定义一个sql
sql = 'select * from userinfo'

# sql = 'insert into userinfo(id,username,password) values(%s,%s,%s)'
cursor.execute(sql,['6','黄飞鸿','666'])
#cursor.fetchall()
cursor.execute(sql)
#ret = cursor.fetchall()
#print(ret)
# conn.commit()
cursor.close()