List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:March 12 2010 3:54pm
Subject:Re: Nested inserts possible?
View as plain text  
Have a look at
last_insert_id()<http://dev.mysql.com/doc/refman/5.1/en/information-functions.html#function_last-insert-id>
.

On Fri, Mar 12, 2010 at 3:48 PM, Keith Clark <keithclark@stripped>wrote:

> I have two tables and I have data to insert into both at the same time,
> but the second table depends on an ID that is auto created in the first
> table.  I'm not sure exactly how to accomplish this.
>
> Table_One
>
> Table_One_Index_ID
> Data_One
> Date_Two
>
> Table_Two
>
> Table_Two_Index_ID
> Table_One_Index_ID
> Data_Three
> Data_Four
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Thread
Nested inserts possible?Keith Clark12 Mar
  • Re: Nested inserts possible?mos12 Mar
  • Re: Nested inserts possible?Johan De Meersman12 Mar
Re: Nested inserts possible?Keith Clark12 Mar
  • RE: Nested inserts possible?Gavin Towey12 Mar