2025年pymysql（pymysql的基本使用）

科技前沿 • 2025-05-24 17:28 • 阅读 45

大家好，我是讯享网，很高兴认识大家。

# -- coding:utf-8 -- # Author:Wong Du

讯享网

import pymysql

# 创建链接，相当于建立一个socket conn = pymysql.Connection(host=‘10.0.0.100’, port=3306, user=‘root’, passwd=‘’, db=‘testdb’)

# 建立游标，相当于进入 mysql> 命令操作界面 cursor = conn.cursor()

# 建表，和mysql命令行操作一样 try:

讯享网

讯享网create_table </span>= cursor.execute(<span style="color: rgba(128, 0, 0, 1)">'''</span><span style="color: rgba(128, 0, 0, 1)">create table student( id int not null primary key auto_increment, name char(32) not null, register_date date not null DEFAULT "2018-05-09" ); </span><span style="color: rgba(128, 0, 0, 1)">'''</span><span style="color: rgba(0, 0, 0, 1)">)

except pymysql.err.InternalError as e:

</span><span style="color: rgba(0, 128, 0, 1)">#</span><span style="color: rgba(0, 128, 0, 1)"> print(type(e))</span> <span style="color: rgba(0, 0, 255, 1)">print</span>(<span style="color: rgba(128, 0, 0, 1)">"</span><span style="color: rgba(128, 0, 0, 1)">033[31;1m%s; Do nothing...033[0m</span><span style="color: rgba(128, 0, 0, 1)">"</span> %<span style="color: rgba(0, 0, 0, 1)">e)

# 插入数据 insert = cursor.execute(‘insert into student (name,register_date) values(“junry”, “2017-03-14”);’) insert2 = cursor.execute(‘insert into student (name,register_date) values(“hongfa”, “2015-03-14”);’) insert3 = cursor.execute(‘insert into student (name,register_date) values(“jinglin”, “2016-03-14”);’)

# 查看表数据 select = cursor.execute(‘select * from student;’) for line in cursor.fetchall():

讯享网</span><span style="color: rgba(0, 0, 255, 1)">print</span><span style="color: rgba(0, 0, 0, 1)">(line)

# 修改表数据 update = cursor.execute(‘update student set name=“junwei” where id=1’) select2 = cursor.execute(‘select * from student;’) print(cursor.fetchone())

# 删除表数据 delete = cursor.execute(‘delete from student;’) select3 = cursor.execute(‘select * from student;’) if cursor.fetchall():

</span><span style="color: rgba(0, 0, 255, 1)">print</span><span style="color: rgba(0, 0, 0, 1)">(cursor.fetchall())

else:

讯享网</span><span style="color: rgba(0, 0, 255, 1)">print</span>(<span style="color: rgba(128, 0, 0, 1)">"</span><span style="color: rgba(128, 0, 0, 1)">This is a empty table...</span><span style="color: rgba(128, 0, 0, 1)">"</span><span style="color: rgba(0, 0, 0, 1)">)

# 提交 conn.commit()

cursor.close() # 关闭游标 conn.close() # 关闭连接

# 等等等等。。。

2025年pymysql（pymysql的基本使用）

相关推荐