检查数据库中的空值-失败

SELECT * FROM users WHERE email IS NULL;

import mysql.connector

try:
    connection = mysql.connector.connect(
        host="localhost",
        user="username",
        password="password",
        database="mydatabase"
    )

    cursor = connection.cursor()
    query = "SELECT * FROM users WHERE email IS NULL"
    cursor.execute(query)

    result = cursor.fetchall()
    for row in result:
        print(row)

except mysql.connector.Error as error:
    print("Failed to execute query: {}".format(error))

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