ll1615

恭喜啊

已领，谢谢

我觉得楼主的优化就很好，有些人就是喜欢复制粘贴

DELIMITER $$
CREATE TRIGGER `test`.`tableb_BEFORE_INSERT` BEFORE INSERT ON `tableb` FOR EACH ROW
BEGIN
SET @name = (SELECT name FROM tablea WHERE NEW.aid = tablea.id);
SET NEW.name = @name;
END$$
DELIMITER ;

我这边是显示器关掉再打开