Re: auto increment value in tables

2002-10-15 Thread Jim Lundeen
as far as i know, you can only have one auto_increment field. you'd have insert, then grab the id and update that record, just like you've said. make sure that you grab the last assigned id using a valid method. if it's a sign-up form, do something like the following to make sure you are actua

auto increment value in tables

2002-10-15 Thread Devi Annisetty
Hi I need to insert the same auto increment value in 2 different tables simultaneously. I am new to the MySQL.Is there any function which helps for this type of manipulations? Or I need to store the value in host variable and update the tables with this host variable? Greatly appreciate you tim