mysql 异常码

SHOW ERRORS;

import mysql.connector

try:
    # 连接到MySQL数据库
    db = mysql.connector.connect(
        host="localhost",
        user="yourusername",
        password="yourpassword",
        database="yourdatabase"
    )

    cursor = db.cursor()

    # 尝试插入重复记录
    sql = "INSERT INTO users (id, name) VALUES (%s, %s)"
    val = (1, "John Doe")
    cursor.execute(sql, val)

    db.commit()

except mysql.connector.Error as err:
    print(f"Error: {err}")
    if err.errno == 1062:
        print("Duplicate entry detected. Please check your data.")
    elif err.errno == 1045:
        print("Access denied. Please check your credentials.")
    else:
        print("An unexpected error occurred.")

finally:
    if db.is_connected():
        cursor.close()
        db.close()