Re: Last Inserted ID Using LOAD DATA

2006-09-21 Thread Visolve DB Team
Thanks ViSolve DB Team. - Original Message - From: Michael Stearne [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: Jim Ginn [EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 10:11 PM Subject: Last Inserted ID Using LOAD DATA I have a group of updates that need to be done using LOAD DATA

Last Inserted ID Using LOAD DATA

2006-09-19 Thread Michael Stearne
I have a group of updates that need to be done using LOAD DATA INFILE. Within this file there are some INSERTS. Is there anyway that after an INSERT happens I can use the auto-increment ID that was just generated in the next statement. Similar to PHP's mysql_insert_id() function. Thanks,