Python3.8.6/3/6安装和使用PyMySQL
PyMySQL安装
C:\Program Files\python3.8.6\Scripts>pip install PyMySQL Defaulting to user installation because normal site-packages is not writeable Collecting PyMySQL Downloading PyMySQL-0.10.1-py2.py3-none-any.whl (47 kB) |████████████████████████████████| 47 kB 85 kB/s Installing collected packages: PyMySQL Successfully installed PyMySQL-0.10.1 |
PyMySQL使用
例子1:
import pymysql
# 打开数据库连接
db = pymysql.connect(host = "10.1.1.247", user ="root", password ="123456", db ="demo", port =3306)
# 使用cursor()方法获取操作游标
cursor = db.cursor()
# 使用execute方法执行SQL语句
cursor.execute("SELECT VERSION()")
# 使用 fetchone() 方法获取一条数据
data = cursor.fetchone()
print ("Database version : %s " % data)
# 关闭数据库连接
db.close()
执行结果:
例子2:
import pymysql
# 打开数据库连接
db = pymysql.connect(host = "10.1.1.247", user ="root", password ="123456", db ="demo", port =3306)
# 使用cursor()方法获取操作游标
cursor = db.cursor()
# 使用execute方法执行SQL语句
cursor.execute("SELECT * from USERS ")
# 使用 fetchone() 方法获取所有数据
results = cursor.fetchall()
for it in results:
for i in range(len(it)):
print (it[i])
# 关闭数据库连接
db.close()
执行结果:
把所有查询结果1个字段一个字段展示出来