Hi Paul On Monday 08 April 2002 12:56 am, Paul DuBois wrote: > You're inserting a specific value into the AUTO_INCREMENT field, which > doesn't result in the creation of a new automatic sequence number. > > If you want to insert a record with a specific value in that column, *and* > you want the value to be treated like an AUTO_INCREMENT value, so that > LAST_INSERT_ID() will return that value, then do this: > INSERT INTO customers (customer_id VALUES(LAST_INSERT_ID(10));
Thank you very much indeed for this succinct explanation (and the workaround). This makes sense now, so another small corner of MySQL has been illuminated for me! Thanks again. Kevin --------------------------------------------------------------------- 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