List:General Discussion« Previous MessageNext Message »
From:Keith Clark Date:March 12 2010 3:57pm
Subject:Re: Nested inserts possible?
View as plain text  
Johan,

That seems to be the ticket.  Thanks!

Keith

On Fri, 2010-03-12 at 16:54 +0100, Johan De Meersman wrote:
> Have a look at 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