MySQL创建触发器将内容从同一数据库插入到另一个表中

您可以尝试如下操作：

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