Это старая версия документа.
USE asteriskcdrdb DELIMITER $$ CREATE TRIGGER `before_insert_queue_log` BEFORE INSERT ON `queue_log` FOR EACH ROW BEGIN SET @newname = (SELECT descr FROM asterisk.queues_config WHERE extension=NEW.queuename LIMIT 1); SET NEW.queuename = @newname; END;$$ DELIMITER ;
UPDATE queue_log AS A INNER JOIN asterisk.queues_config AS B ON B.extension=A.queuename SET queuename=descr;