Python3 MySQL 数据库连接基础知识

SQL 查询语句

import pymysql
# 打开数据库连接
db = pymysql.connect("localhost", "environment", "7eiRbMjxG4tahPKy", "environment")

# 使用cursor()方法获取操作游标
cursor = db.cursor()

# SQL 查询语句
sql = "SELECT * FROM po_admin "
try:
    # 执行SQL语句
    cursor.execute(sql)
    # 获取所有记录列表
    results = cursor.fetchall()
    for row in results:
        # 打印结果
        print(row)
except:
    print("Error: unable to fetch data")

# 关闭数据库连接
db.close()

lockdatav Done!