您可以尝试如下操作:
DELIMITER $$
CREATE TRIGGER `ai_user` AFTER INSERT ON user
FOR EACH ROW BEGIN
INSERT INTO highscore_easy
SET
user = NEW.username,
userid = NEW.userid,
time = 0,
date = 0,
level = 0;
END
在单个触发器中,您可以根据需要插入任意数量的插入物:
DELIMITER $$
CREATE TRIGGER `ai_user` AFTER INSERT ON user
FOR EACH ROW BEGIN
INSERT INTO highscore_easy
SET
user = NEW.username,
userid = NEW.userid,
time = 0,
date = 0,
level = 0;
INSERT INTO highscore_expert
SET
user = NEW.username,
userid = NEW.userid,
time = 0,
date = 0,
level = 0;
END