python操作mysql的增删改查

import pymysql
conn = pymysql.connect(host='127.0.0.1',port=3306,user='root',passwd='123',db='orm01')
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)

增

sql = " insert into app01_userinfo values(0,%s,11,'2010-09-11');"
for i in range(1,10000):
ret = cursor.executemany(sql,[('alex'),('db'),('sb'),('123')])

获取最后一个自增id

res = cursor.lastrowid
print(res)

删

sql = "delete from t1 where name='alex';"

cursor.execute(sql)

改

sql = "update t1 set name='jack' where name='sb'"

cursor.execute(sql)

查

sql = "select * from t1"

cursor.execute(sql)

rer = cursor.fetchall()

print(rer)

数据有改动就要提交

conn.commit()
cursor.close()
conn.close()