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 insertChange 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

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

column

The data to insert into columns. For more information, see column.

Note: YAML and JSON changelogs using the column tag must nest it within a columns tag.

all

XML example

<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>

YAML example

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

JSON example

{
  "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"
		   }
	     }
	   ]
     }
   }

SQL example

-- changeset DocUser:1:insertSQLChangeType
INSERT  INTO  department.person  (address)  VALUES  ('address value');

Database support