分类：操作MySQL

2021
09-04

python使用pymysql模块操作MySQL

目录实例一：插入数据实例二：获取某个表全部数据实例三：根据cName模糊搜索实例四：修改数据实例五：删除数据实例一：插入数据importpymysqlimporttkinterastkconn=pymysql.connect(host='localhost',user='root',passwd='root',db='okzl',charset='utf8')master=tk.Tk()master.title("插入供应商信息")master.geometry('350x300')tk.Label(master,text='cName').place(x=30,y=10)tk.Label(master,text='address').... 继续阅读 >
2021
06-29

用python开发一款操作MySQL的小工具

目录项目地址安装导入使用1创建连接2执行sql语句​3 select方法4insert_into方法5merge_into方法6replace_into方法7update方法8delete方法9使用事务10读取流式游标结果项目地址https://github.com/lishukan/directsql安装pip3installdirectsql导入directsql目前只提供三个外部类__all__=["SqlGenerator","MysqlConnection","MysqlPool"]导入方式fromdirectsql.sqlgeneratorimportSqlGenerator... 继续阅读 >
2021
03-30

python操作mysql、excel、pdf的示例

一、学习如何定义一个对象代码：#!/usr/bin/python#-*-coding:UTF-8-*-#1.定义Person类classPerson:def__init__(self,name,age):self.name=nameself.age=agedefwatch_tv(self):print(f'{self.name}看电视')#2.定义loop函数#打印1-max中的奇数deftest_person():person=Person('Jake',20)print(f'打印person的地址：',person)print(f'person.name:{person.name}')print(f'person.... 继续阅读 >
2020
10-10

使用Python操作MySQL的小技巧

1、获取插入数据的主键idimportpymysqldatabase=pymysql.connect(host="127.0.0.1",port=3306,user="root",password="root",database="test")cursor=database.cursor()foriinrange(5):cursor.execute('insertintotest(name)values("test")')print(database.insert_id())database.commit()cursor.close()database.close()通过db.insert_id()方法可以获取插入数据的主键id,注意一定要在commit之前获取... 继续阅读 >
2020
10-08

Python操作MySQL数据库的示例代码

1.MySQLConnector1.1创建连接importmysql.connectorconfig={"host":"localhost","port":"3306","user":"root","password":"password","database":"demo"}con=mysql.connector.connect(**config)importmysql.connectorconfig={"host":"localhost","port":"3306","user":"root","password":"password","database":"demo"}con=mysql.connector.connect(**config)1.2Cursorimportmysql.connectorcon=... 继续阅读 >