pymysql模块，python与MySQL之间的交互（python pymysql用法）

pymysql模块，python与MySQL之间的交互（python pymysql用法）

import pymysqldb = pymysql.connect(host="192.168.137.1", port=3306, user="wu", password="123456", db="爸爸测试", charset="utf8") #这是个坑啊utf-8没有-# cursor = db.cursor()# sql = "select * from boy"# 这是一个坑，拼接字符串的坑# sql = "select * from t1 where user = %s and pwd = %s"# return_value = cursor.execute(sql,("wu","sda"))# sql = "insert into boy(name,age) values(%s,%s)"# return_value = cursor.execute(sql,("老九",1))# return_value = cursor.executemany(sql,[(),(),()])cursor = db.cursor(pymysql.cursors.DictCursor) #传参，输出结果为字典# print(cursor.lastrowid) 插入的时候看光标sql = "select * from boy"return_value = cursor.execute(sql)print(cursor.fetchone())# cursor.scroll(3,mode="relative")cursor.scroll(0,mode="absolute")print(cursor.fetchall())# result = cursor.fetchall()# # print(db)# print(return_value)# print(result)db.commit()cursor.close()db.close()

-----------------------------------------------------------------------------------------------------------------------------------------

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。