mysql查询

DELIMITER //

CREATE PROCEDURE InsertStudentData(
    IN p_username VARCHAR(50),
    IN p_introduce TEXT
)
BEGIN
    -- 检查用户名是否以张、王、李、赵开头
    IF LEFT(p_username, 1) = '张' OR 
       LEFT(p_username, 1) = '王' OR 
       LEFT(p_username, 1) = '李' OR 
       LEFT(p_username, 1) = '赵' THEN
        SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Username cannot start with 张, 王, 李, or 赵';
    END IF;
    
    -- 插入数据到student表
    INSERT INTO student (createDate, username, introduce)
    VALUES (CURDATE(), p_username, p_introduce);
END //

DELIMITER ;