Hello everyone, I have a situation where I have to use different delimiter in my migration sql file. I wanted to know if it was possible or if I had to declare several changeSet with different “endDelimiter”?
I would like to do something like this :
DROP TABLE IF EXISTS `city`; CREATE TABLE `city` ( `uid` INT AUTO_INCREMENT PRIMARY KEY, `name` VARCHAR(255) NOT NULL ); DELIMITER $ CREATE OR REPLACE PROCEDURE fillCityTable() BEGIN INSERT INTO city (name) VALUES ('Paris'); INSERT INTO city (name) VALUES ('London'); END; $ DELIMITER ; CALL fillCityTable(); DROP PROCEDURE fillCityTable;
I asked the question in another way on stack overflow if you want:
I thank you in advance