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