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 <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