前言

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()

结语

… …