admin管理员组

文章数量:1122832

When I create a MySQL dump that includes triggers, I get lines looking like

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`example_user`@`%`*/ /*!50003 TRIGGER `tablename_AFTER_UPDATE` AFTER UPDATE ON `tablename` FOR EACH ROW INSERT INTO `schema`.`log_tablename` (action, id, value) VALUES ('update', NEW.id, NEW.value) */;;
DELIMITER ;

If I try to import that dump file into Dolt, I get an Error along the lines of

failed to prepare import job: syntax error at position 12 near 'DELIMITER'

How can I fix this? Manually running the Trigger Create statements one by one is possible, but would be extremely time consuming, as we probably have a hundred of them in our database.

本文标签： Dolt How to import Triggers from MySQLStack Overflow

版权声明：本文标题：Dolt: How to import Triggers from MySQL - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736305143a1932486.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。