MySQL5.6 触发器的使用(条件分支、变量的使用)
use fs;/*product_info表中,仪器和试剂一定是不同的产品,id上不可能重复,可以放心删*/create trigger check_record_delete_trigger after DELETEon check_record FOR EACH ROWbeginset @count = (select count(*) from check