DELIMITER $$
CREATETRIGGER sex__check BEFORE INSERTON tb_student FOR EACH ROWBEGINDECLARE ssex CHAR(5);SET ssex=new.stusex;IF(ssex='男'OR ssex='女')THENSET@choice=1
查看触发器show triggers删除触发器drop trigger 触发器名触发器模板触发器模板,有什么别的条件把其中的一块改动就可以了性别只能为‘男’或‘女’DELIMITER $$CREATE TRIGGER sex__check BEFORE INSERT ON tb_student FOR EACH ROWBEGINDECLARE ssex CHAR(5);SET...