data insertion based on a select

General Discussion
1

I’m not sure if the standard tag will work. You may just need to use and include that SQL directly.


Nathan

2

Hi folks,


I’m trying to refactor an SQL script into a Liquibase script and I can’t figure out how to refactor this peace of code :


  1. INSERT INTO APP_TABLE_ENTITY_SET_DE ("TABLE_ENTITY_SET_ID","TABLE_ENTITY_ID") SELECT  (SELECT ID FROM APP_TABLE_ENTITY_SET WHERE NAME='Central'),ID FROM APP_TABLE_ENTITY;

Is it possible with Liquibase ?


Thanks in advance,


Anthony

3

Indeed, that’s the only way I have found.


(Sorry for the late reply)