ll1615

ll1615

V2EX member #276431, joined on 2017-12-23 10:58:19 +08:00
ll1615's recent replies
Feb 10, 2022
Replied to a topic by 312ybj 生活 结婚这件大事
恭喜啊
已领,谢谢
我觉得楼主的优化就很好,有些人就是喜欢复制粘贴
Sep 4, 2020
Replied to a topic by chensong004 问与答 求教一个 mysql 跨表同步问题
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 ;
我这边是显示器关掉再打开
About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   3093 Online   Highest 6679   ·     Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 18ms · UTC 00:24 · PVG 08:24 · LAX 17:24 · JFK 20:24
♥ Do have faith in what you're doing.