| 知乎专栏 |
触发器中不允许返回结果集,解决方法是顶一个变量,然后将返回值返回给变量。
DROP TRIGGER IF EXISTS `test`.`demo_AFTER_INSERT`;
DELIMITER $$
USE `test`$$
CREATE DEFINER=`root`@`%` TRIGGER `test`.`demo_AFTER_INSERT` AFTER INSERT ON `demo` FOR EACH ROW
BEGIN
set @rev = "";
SELECT
OUT2FILE('/tmp/demo.log',
CONCAT_WS(',',
NEW.id,
NEW.name,
NEW.sex,
NEW.address))
INTO @rev;
END$$
DELIMITER ;