dbmate icon indicating copy to clipboard operation
dbmate copied to clipboard
verified publisher icon amacneil

dbmate load fails on SQL files containing DELIMITER statements

Open garfildalex6 opened this issue 3 months ago • 1 comments

When running dbmate load with a SQL file that contains DELIMITER commands (used for defining triggers or stored procedures), the command fails with a syntax error, e.g.:

Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER ;; ...' at line 1

  • Version: 2.28.0
  • Database: MYSQL 5.7
  • Operating System: Windows 10

garfildalex6 avatar Sep 23 '25 19:09 garfildalex6