python 操作mysql

import pymysql

host = ‘localhost’
user = ‘root’
password = ‘’
port = 3306
db = ‘test’

#连接
conn = pymysql.connect(host=host,user=user,password=password,port=port,db=db)
#建立游标
curr = conn.cursor()

#查询
sql = ‘select * from test_stock’
curr.execute(sql)
data = curr.fetchall()
for i in data:
print(i)
print(f"{'*‘100}“)
#修改
upd = ‘update test_stock set product_sku=“cde” where id=1;’
curr.execute(upd)
sql1 = ‘select * from test_stock’
curr.execute(sql1)
data = curr.fetchall()
for i in data:
print(i)
print(f”{'’*100}")

#新增
ins = ‘insert into test_stock values (8,789,6,“efg”);’
curr.execute(ins)
sql1 = ‘select * from test_stock’
curr.execute(sql1)
conn.commit()
data = curr.fetchall()
for i in data:
print(i)
print(f"{‘*’*100}")

#删除
dee = ‘delete from test_stock where id=8;’
curr.execute(dee)
conn.commit()
sql1 = ‘select * from test_stock’
curr.execute(sql1)
data = curr.fetchall()
for i in data:
print(i)
print(f"{‘*’*100}")

curr.close()
conn.close()