MySQL 中的 OR 非空约束

MySQL中的OR非空约束

sql
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(50),
    CONSTRAINT check_name_or_email CHECK (name IS NOT NULL OR email IS NOT NULL)
);

python
import mysql.connector
# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="root",
    password="password",
    database="test"
)
# 创建游标对象
cursor = db.cursor()
# 插入用户信息
def insert_user(name, email):
    try:
        # 执行插入操作
        sql = "INSERT INTO users (name, email) VALUES (%s, %s)"
        values = (name, email)
        cursor.execute(sql, values)
        db.commit()
        print("用户信息插入成功！")
    except mysql.connector.Error as error:
        print("插入用户信息失败：{}".format(error))
        db.rollback()
# 测试插入用户信息
insert_user("John Doe", "")
insert_user("", "johndoe@example.com")
insert_user("Alice Smith", "alice@example.com")
# 关闭游标和数据库连接
cursor.close()
db.close()