使用 SQLAlchemy 操作数据库

python sql

import pymysql

con = pymysql.connect(
    host='localhost',
    user='root',
    passwd='1234',
    database='air_quality'
)

try:
    with con.cursor() as cur:
        cur.execute('SELECT VERSION()')
        version = cur.fetchone()
        print(f'Database version: {version[0]}')
finally:
    con.close()

con = pymysql.connect(
    host='localhost',
    user='root',
    passwd='1234',
    database='air_quality'
)

try:
    with con.cursor() as cur:
        cur.execute('SELECT * FROM irr_28')
        rows = cur.fetchall()
        for row in rows:
            print(f'{row[0]} {row[1]} {row[2]}')
finally:
    con.close()

前言

结语

参考