How to execute multiple inserts when using LIQUIBASE WITHOUT CHANGELOGS

Question

As per this documentation

Liquibase can execute multiple sql files in a given path without the need of any changelogs. However when I created the file with below inserts

insert into address (id, line1, line2) values (1, '121 Main Ave', null);
insert into address (id, line1, line2) values (2, '662 Broadway', 'Suite 3317');
insert into address (id, line1, line2) values (3, '412 Riverview', null);

I get the following error

Invalid sql syntax

Answer 1

Liquibase is not recognising your sql file . Add these 2 lines on top of you sql file :

--liquibase formatted sql
--changeset {authorName}:{id}

change authorName and id as per your wish . You can also do something like this in your changelog.xml file:

<changeSet author="authorName" id=”id”>
  <sqlFile path="insertcommands.sql"/>
</changeSet>

In this case you need not put on top of your insertcommands.sql file

--liquibase formatted sql
--changeset {authorName}:{id}

as you did earlier.

PS - Tested on liquibase-3.4 and mysql5.5