How to use multiple "endDelimiter" in a liquidbase sql migration file?

General Discussion
1

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 :slight_smile:

2

Best practice is to put each DDL statement is a separate changeset.