reading an identity column and inserting it in to other table

[Rashid Jilani]

Hi: guys can some one shed some light how to read an identity column in
mysql and update the other table with the identity value.

 

E.g  <insert id="inseretIntoUser"
parameterClass="com.lifebiosystems.domain.RegisteredUser">

        INSERT INTO address(zip, country)

        VALUES(#address.zip#, #address.country#)

        <selectKey resultClass="int" >

            SELECT @@IDENTITY AS id

        </selectKey>

    </insert>

 

I am not sure how to read the value of id and use in a different insert
statement

 

Thanks,

RJ