fetchall()返回的是元组类型
插入数据需要进行确认(commit)或者设置自动确认:
from pymysql import Connection
# 构建mysql数据库的连接(构建对象)
conn = Connection(
host='localhost',
port=3306,
user='root',
password='123456'
)
# print(conn.get_server_info())
# 执行非查询性质的MySQL语句
cursor = conn.cursor() # 获取游标对象
conn.select_db("world") # 选择数据库
# cursor.execute("create table test_pymysql(id int);")
# 执行查询性质的MySQL语句
cursor.execute("select * from student;")
results: tuple = cursor.fetchall()
for r in results:
print(r)
# 关闭数据库
conn.close()
实战案例: