mysql咋限定字段的范围

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    age TINYINT CHECK (age >= 0 AND age <= 120)
);

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    price FLOAT CHECK (price >= 0 AND price <= 10000)
);

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50) CHECK (LENGTH(name) BETWEEN 2 AND 50)
);

DELIMITER $$
CREATE TRIGGER check_age_before_insert
BEFORE INSERT ON example
FOR EACH ROW
BEGIN
    IF NEW.age < 0 OR NEW.age > 120 THEN
        SIGNAL SQLSTATE '45000'
        SET MESSAGE_TEXT = 'Age must be between 0 and 120';
    END IF;
END$$
DELIMITER ;

def insert_data(age):
    if age < 0 or age > 120:
        raise ValueError("Age must be between 0 and 120")
    # 执行插入操作

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    email VARCHAR(255) CHECK (email REGEXP '^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,}$')
);