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 specific data or values to an existing table in your database. It can include columns and other attributes listed in this documentation.

Running the insert Change Type

To run this Change Type, follow these steps:

  1. Add the Change Type to your changeset, as shown in the examples on this page.

  2. Specify any required attributes. Use the table on this page to see which ones your database requires.

  3. 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(s)a changeset will be used for. See valid database type names on dbms. Separate multiple databases with commas. Specify that a changeset is not applicable to a particular database type by prefixing with !.The keywords all and none are also available.

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 column tag must nest it within a columns tag.

The insert change type requires at least one column to insert data into.

all

all

Database support

Database

Note

Auto Rollback

DB2/LUW

Supported

No

DB2/z

Supported

No

Derby

Supported

No

Firebird

Supported

No

Google BigQuery

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

insert examples

--liquibase formatted sql
--changeset liquibase-docs:sql-1
CREATE TABLE sql_table (
  stringValue VARCHAR(100),
  numericValue INT,
  booleanValue BOOLEAN,
  nullExample VARCHAR(100)
);


--changeset liquibase-docs:sql-2 
INSERT INTO
  sql_table (
    stringValue,
    numericValue,
    booleanValue,
    nullExample
  )
VALUES
  ('Text value', 123, TRUE, NULL);