Issue with tranfering data from one table to another in 1 db

General Discussion
1

have table1 with columns(id, name, age) and table2 with columns(id, name, age). I decide to transfer data from table1 to table2 because I want to use table1 for other things. Both tables created with liquibase.

Script main body: <changeSet id="1" <sql> INSERT INTO table2(id, name, age) SELECT id, name, age FROM table1 </sql> </changeSet> .

After running project with spring.liquibase script work out but nothing was transferred.

2

Hi @Deverlain

Could you please help us with more details:

  1. DB you are using.
  2. Liquibase version you are using.
  3. Error/Messgae you get after running liquibase update command.
  4. Your changelog file and the command you run.

Thanks,
Rakhi Agrawal