insert
The insert
Change Type inserts data into an existing table.
Uses
You can typically use the insert
Change Type when you want to add and deploy the specific data or values to the existing table in your database. It can include columns and another attributes listed in this documentation.
Running the update
Change Type
To insert the needed data and update a table in your database, follow these steps:
- Add the
insert
Change Type to your changeset with the needed attributes as it is shown in the examples. - Deploy your changeset by running the
update
command:
liquibase update
Now, you should see that your data has been inserted into the table.
Available attributes
Name | Description | Required for | Supports | Since |
---|---|---|---|---|
catalogName
|
Name of the catalog |
all | 3.0 | |
dbms
|
Specifies which database type |
all | 3.0 | |
schemaName
|
Name of the schema |
all | ||
tableName
|
Name of the table to insert data into | all | all |
Nested tags
Name | Description | Required for | Supports | Multiple allowed |
---|---|---|---|---|
column
|
The data to insert into columns. Note: YAML and JSON changelogs using the |
-- | all | all |

...
<changeSet author="liquibase-docs" id="insert-example">
<insert catalogName="department"
dbms="!h2, mysql"
schemaName="public"
tableName="person">
<column name="address" value="address value"/>
</insert>
</changeSet>
...

...
- changeSet:
id: insert-example
author: liquibase-docs
changes:
- insert:
catalogName: department
columns:
- column:
name: address
value: address value
dbms: '!h2, mysql'
schemaName: public
tableName: person
...

...
{
"changeSet":{
"id":"insert-example",
"author":"liquibase-docs",
"changes":[
{
"insert":{
"catalogName":"department",
"columns":[
{
"column":{
"name":"address",
"value":"address value"
}
}
],
"dbms":"!h2, mysql",
"schemaName":"public",
"tableName":"person"
}
}
]
}
}
...

...
--changeset liquibase-docs:insert-example
INSERT INTO department.person (address) VALUES ('address value');
...
Database support
Database | Note | Auto Rollback |
---|---|---|
DB2/LUW | Supported | No |
DB2/z | Supported | No |
Derby | Supported | No |
Firebird | Supported | No |
H2 | Supported | No |
HyperSQL | Supported | No |
INGRES | Supported | No |
Informix | Supported | No |
MariaDB | Supported | No |
MySQL | Supported | No |
Oracle | Supported | No |
PostgreSQL | Supported | No |
Snowflake | Supported | No |
SQL Server | Supported | No |
SQLite | Supported | No |
Sybase | Supported | No |
Sybase Anywhere | Supported | No |