Python操作MySQL

安装第三方库pymysql（设置->项目内的python解释器_>+） 1、获取连接对象

from pymysql import Connection #构建到MySQL数据库的连接 conn = Connection( host = "localhost", port = 3306, user = "root", password = "****", autocommit=True#修改操作自动提交，否则需要加conn mit() ) #关闭连接 conn.close()

2、执行SQL查询

#获取游标对象 cursor = conn.cursor() #选择数据库 conn.select_db("test") #执行非查询性质SQL # cursor.execute("create table test_pymysql(id int);") #执行查询性质SQL cursor.execute("SELECT * FROM student") #获取查询结果 results: tuple = cursor.fetchall() #fetchall——获取所有 for r in results: print(r)

完成代码如下

""" 演示Python pymysql库的基础操作 """ from pymysql import Connection #构建到MySQL数据库的连接 conn = Connection( host = "localhost", port = 3306, user = "root", password = "0000", autocommit=True ) #关闭连接 conn.close() # print(conn.get_server_info()) #获取游标对象 cursor = conn.cursor() #选择数据库 conn.select_db("test") #执行非查询性质SQL # cursor.execute("create table test_pymysql(id int);") #执行查询性质SQL cursor.execute("SELECT * FROM student") #获取查询结果 results: tuple = cursor.fetchall() #fetchall——获取所有 for r in results: print(r) #关闭连接 conn.close()

注：查看mysql版本，同时也可作为测试是否连接成功语句

print(conn.get_server_info())