Hi All I am new to MY SQL .
I am writing a script where I will have 2 insert statements The first insert is into a table which has an Auto_Increment field. I want to know the value which was inserted in this Auto_increment field and use it in the second INSERT statement. How can I do it in MySQL. Rajesh Kanade 8 Janapriya 34/1 Erandwane Pune 4 http://www.geocities.com/rrkanade --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php