触发器:
CREATE TRIGGER SCHOOL_disable_QUESTION AFTER DELETE ON DB_SCHOOL FOR EACH ROW update DB_QUESTION t set t.STATE_TAG='0' where t.SCHOOL_ID=OLD.SCHOOL_ID;
命令行执行.sql文件
mysql->source C:\mysql\a.sql
触发器:
CREATE TRIGGER SCHOOL_disable_QUESTION AFTER DELETE ON DB_SCHOOL FOR EACH ROW update DB_QUESTION t set t.STATE_TAG='0' where t.SCHOOL_ID=OLD.SCHOOL_ID;
命令行执行.sql文件
mysql->source C:\mysql\a.sql