thanks a simple but effective explination.
-----Original Message----- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: 23 January 2002 22:29 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Can Anyone explain / help with auto_increment fields. At 10:23 PM 1/23/2002 +0000, you wrote: >Hi, > >I have a blank table for some testing. > >1 of the fields (the primary key) is an auto_increment and not null. > >how and what do I insert into this field to start off the recordsets. also >once I have set the records going say to 1, what do I then insert if >anything into this field for the next record ?? can some one give me a brief >explaination of the auto_increment field. Do not insert any value into that column. It will be given a value automagically. --------------------------------------------------------------------- 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