用pip安裝模塊pymysql
sudo pip3 install pymyslq3
使用pymysql連接mysql
import pymysql
conn = pymysql.connect(host='127.0.0.1',port=3306,user='root',passwd='123456',db='testdb')
cur= conn.cursor()
cur.execute("SELECT 1")
forrincur.fetchall():
? ? print(r)
cur.close()
conn.close()
