mysql 语句检测

import mysql.connector
from mysql.connector import errorcode

try:
    cnx = mysql.connector.connect(user='user', password='password',
                                  host='host', database='database')
    cursor = cnx.cursor()

    # 示例SQL语句
    sql = "SELECT * FROM users WHERE id = %s"

    # 检查SQL语句语法
    try:
        cursor.execute(sql, (1,))
    except mysql.connector.Error as err:
        if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
            print("Something is wrong with your user name or password")
        elif err.errno == errorcode.ER_BAD_DB_ERROR:
            print("Database does not exist")
        else:
            print(err)

    cursor.close()
    cnx.close()

except mysql.connector.Error as err:
    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
        print("Something is wrong with your user name or password")
    elif err.errno == errorcode.ER_BAD_DB_ERROR:
        print("Database does not exist")
    else:
        print(err)