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 > <keithcl...@k-wbookworm.com> 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=vegiv...@tuxera.be > > > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
