Define Changeset for insert query in liquibase Define Changeset for insert query in liquibase sql sql

Define Changeset for insert query in liquibase


Use the valueComputed attribute:

<changeSet author="unknown" id="insert-example-2">    <insert tableName="StudentClassMap">        <column name="studentId" valueComputed="(SELECT sId from StudentMaster where studentName='Jay Parikh')"/>        <column name="studentClass" value="McSc. 1st Year"/>    </insert></changeSet>