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
