A new topic, 'Using result from one changeset in another', has been made on a
board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=644.new#new
The text of the topic is shown below:
Hi, Nathan!
I'm using MySQL and have the following problem:
I have to insert a row in one autoinremented table and then use inserted id of
that record in another changeset.
I could manage it only with <sql> tag, is there a way to do it using <insert>?
Or maybe save some value in <parameter/> block?
Code:
<changeSet id="1" author="confik">
<insert tableName="modules">
<column name="name" value="marketing"/>
</insert>
</changeSet>
<changeSet id="2" author="confik">
<!-- added additional modules access rights -->
<sql>
INSERT INTO module_access (module_id, type) SELECT id, 'view'
FROM modules WHERE name = 'marketing'
</sql>
</changeSet>
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The Liquibase Community Forum Team.------------------------------------------------------------------------------
This SF.net email is sponsored by
Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
