python3连接mysql数据库
1 2 3 |
//用到模块pymysql,用pip安装 sudo pip3 install pymysql3 或 sudo apt install python3-pymysql |
编写程序
1 2 3 4 5 6 7 8 9 |
import pymysql conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123',db='girl') cur = conn.cursor() cur.execute("SELECT * FROM student") for r in cur.fetchall(): print(r) cur.close() conn.close() |
转载请注明:人工智能笔记 » python3连接mysql数据库