import pymysql
pymysql.install_as_MySQLdb()
import MySQLdb

image.png

db = MySQLdb.connect("127.0.0.1", "root", "123456", "50exercise")

cursor = db.cursor()
sql = "SELECT * FROM 50exercise.course;"

try:
    # 執(zhí)行sql語句
    cursor.execute(sql)
    results = cursor.fetchall()
    print(results)


except:
    # 發(fā)生錯誤時回滾
    db.rollback()

# 關(guān)閉數(shù)據(jù)庫連接
db.close()

image.png

與pandas 聯(lián)動

import pandas as pd

# 下面?zhèn)魅氲膮?shù)依次是(ip,username,userpassword,databases)
conn = pymysql.connect("127.0.0.1", "root", "123456", "50exercise")
sql = "SELECT * FROM 50exercise.course;"
df=pd.read_sql_query(sql,conn)
print(df.head())

image.png