前言
python通过pymysql模块实现对数据库的更删改查等的操作
使用示例
import pymysql
# 连接ip,数据库用户,数据库密码,数据库,字符集
connect_db = pymysql.connect("192.168.110.225", "root", "1234", "test", charset="utf8")
# 获取游标
cursor = connect_db.cursor()
# 插入数据
# sql = "insert into info (name, class) values ('shangsi', 'mingwu')"
# 修改数据
# sql = "update info set class='four' where name='shangsi'"
# 删除数据
# 查询数据
# sql = "select * from info"
## sql = "select name from info where class='one'"
# cursor.execute(sql)
# results = cursor.fetchall()
## results = cursor.fetchone()
# print(results)
# 删除数据
sql = "delete from info where class='four'"
# 执行sql语句
cursor.execute(sql)
# 使sql语句执行数据库操作并生效
connect_db.commit()
# 关闭数据库
connect_db.close()
结语
… …