Change: ‘insert’

Inserts data into an existing table

Available Attributes

NameDescriptionRequired ForSupportsSince
catalogNameName of the catalogall3.0
dbmsall3.0
schemaNameName of the schemaall
tableNameName of the table to insert data intoallall

Nested Properties

NameDescriptionRequired ForSupportsMultiple AllowedSince
columnsData to insert into columns

See the column tag documentation for more information
allallyes
<changeSet author="liquibase-docs" id="insert-example">
    <insert catalogName="cat"
            dbms="h2, oracle"
            schemaName="public"
            tableName="person">
        <column name="address" type="varchar(255)"/>
    </insert>
</changeSet>
changeSet:
  id: insert-example
  author: liquibase-docs
  changes:
  - insert:
      catalogName: cat
      columns:
      - column:
          name: address
          type: varchar(255)
      dbms: h2, oracle
      schemaName: public
      tableName: person
{
  "changeSet": {
    "id": "insert-example",
    "author": "liquibase-docs",
    "changes": [
      {
        "insert": {
          "catalogName": "cat",
          "columns": [
            {
              "column": {
                "name": "address",
                "type": "varchar(255)"
              }
            }]
          ,
          "dbms": "h2, oracle",
          "schemaName": "public",
          "tableName": "person"
        }
      }]
    
  }
}

SQL Generated From Above Sample (MySQL)

INSERT INTO cat.person (address) VALUES (NULL);

Database Support

DatabaseNotesAuto Rollback
DB2SupportedNo
DerbySupportedNo
FirebirdSupportedNo
H2SupportedNo
HyperSQLSupportedNo
InformixSupportedNo
MySQLSupportedNo
OracleSupportedNo
PostgreSQLSupportedNo
SQL ServerSupportedNo
SQLiteSupportedNo
SybaseSupportedNo
Sybase AnywhereSupportedNo

Missing, incomplete or wrong information? Please send a pull request