pymysql增删改查

# import pymysql
#
# # 建立连接
# conn = pymysql.connect(host=‘192.168.31.27‘, port=3306, user=‘root‘, password=‘123‘, database=‘db2‘, charset=‘utf8‘)
# # 游标
# cursor = conn.cursor()  # 执行完毕返回的结果集默认以元组显示
# # 执行sql


# 增删改查

sql = ‘insert into userinfo(user,pwd) values(%s,%s)‘
# rows = cursor.execute(sql, (‘wxx‘, ‘123‘))
# # print(rows)
# res=cursor.executemany(sql,[("root","123456"),("lhf","12356"),("eee","156")])
#
# conn.commit()

# res=cursor.execute(sql) #执行sql语句，返回sql影响成功的行数
# print(res)

# 关闭
# cursor.close()
# conn.close()


# import pymysql
# #链接
# conn = pymysql.connect(host=‘192.168.31.27‘, port=3306, user=‘root‘, password=‘123‘, database=‘db2‘, charset=‘utf8‘)
# #游标
# cursor=conn.cursor()
#
# #执行sql语句
# sql=‘select * from userinfo;‘
# rows=cursor.execute(sql) #执行sql语句，返回sql影响成功的行数rows,将结果放入一个集合，等待被查询
#
# # cursor.scroll(3,mode=‘absolute‘) # 相对绝对位置移动
# # cursor.scroll(3,mode=‘relative‘) # 相对当前位置移动
# res1=cursor.fetchone()
# res2=cursor.fetchone()
# res3=cursor.fetchone()
# res4=cursor.fetchmany(2)
# res5=cursor.fetchall()
# print(res1)
# print(res2)
# print(res3)
# print(res4)
# print(res5)
# print(‘%s rows in set (0.00 sec)‘ %rows)
#
#
#
# conn.commit() #提交后才发现表中插入记录成功
# cursor.close()
# conn.close()
#
# ‘‘‘
# (1, ‘root‘, ‘123456‘)
# (2, ‘root‘, ‘123456‘)
# (3, ‘root‘, ‘123456‘)
# ((4, ‘root‘, ‘123456‘), (5, ‘root‘, ‘123456‘))
# ((6, ‘root‘, ‘123456‘), (7, ‘lhf‘, ‘12356‘), (8, ‘eee‘, ‘156‘))
# rows in set (0.00 sec)
# ‘‘‘


import pymysql

conn = pymysql.connect(host=‘192.168.31.27‘, port=3306, user=‘root‘, password=‘123‘, database=‘db2‘, charset=‘utf8‘)
cursor = conn.cursor()

sql = ‘insert into userinfo(user,pwd) values("wxx","123");‘
rows=cursor.execute(sql)
print(cursor.lastrowid) #在插入语句后查看

conn.commit()

cursor.close()
conn.close()

pymysql增删改查

原文：https://www.cnblogs.com/hamao/p/10808499.html