python 连接数据库

首先下载pymysql包pip install pymysql完整案例import pymysqldb = pymysql. pymysql.connect(host='127.01.01', port=3306, user='root', passwd='123', db='demo', charset='utf8')cursor = db.cursor()#创建链接对象sql = "selec

好码

83人浏览 · 2021-09-01 15:14:30

好码 · 2021-09-01 15:14:30 发布

首先下载pymysql包

pip install pymysql

完整案例

import pymysql

db = pymysql. pymysql.connect(host='127.01.01', port=3306, user='root', passwd='123', db='demo', charset='utf8')
cursor = db.cursor()#创建链接对象
sql = "select * from demo.test"
cursor.execute(sql)
data = cursor.fetchone()#获取执行结果
db.close()