mysql触发器遍历结果集
DELIMITER // CREATE TRIGGER example_trigger BEFORE INSERT ON example_table FOR EACH ROW BEGIN DECLARE var_count INT; DECLARE var_index INT DEFAULT 0; DECLARE var_id INT; SELECT COUNT(*) INTO var_count FROM example_table; WHILE var_index