import pymysql
conn = pymysql.Connect(
user = 'root',
port = 3306,
host = '127.0.0.1',
password = '1234',
database = 'test', #库名
charset = 'utf8',
)
cursor = conn.cursor(cursor = pymysql.cursors.DictCursor) #设置输出格式为字典,默认为元组
# sql = 'select id,name from test1' #表名
# cursor.execute(sql)
# data = cursor.fetchall()
# print(data)
# conn.close()
# #插入
# sql = 'insert into test1(id,name) values(%s,%s)'
# cursor.execute(sql,[4,'lz1'])
# conn.commit()
#删除
# sql = 'delete from test1 where id=1'
# cursor.execute(sql)
# conn.commit()
#改
sql = 'update test1 set name=%s where id=%s'
cursor.execute(sql,['lz3',3])
conn.commit()
数据库基本连接和增删改查
最新推荐文章于 2022-09-12 21:51:44 发布