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:
Step 1: Add the insert
Change Type to your changeset with the needed attributes as it is shown in the examples.
Step 2: 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
|
The name of the catalog. | all | 3.0 | |
dbms
|
Specifies which database types the change must be applied to. Valid database type names are listed on the supported databases page. Separate multiple databases with commas. Specify that a change does not apply to a database type by prefixing it with ! . The keywords all and none are also available. |
all | 3.0 | |
schemaName
|
The name of the schema. | all | ||
tableName
|
The name of the table for which to insert data. | all | all |
Nested properties
Name | Description | Required for | Supports | Multiple allowed |
---|---|---|---|---|
column
|
The data to insert into columns. For more information, see column. 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 DocUser:1:insertSQLChangeType
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 |