Matthew, Thursday, January 24, 2002, 12:30:13 AM, you wrote:
MD> thanks a simple but effective explination. You can insert whatever you want in that field - here applies all the rules of a primary key. But when you insert zero (or nothing), the database server will insert the next available free value. MD> -----Original Message----- MD> From: Christopher Thompson [mailto:[EMAIL PROTECTED]] MD> Sent: 23 January 2002 22:29 MD> To: [EMAIL PROTECTED]; [EMAIL PROTECTED] MD> Subject: Re: Can Anyone explain / help with auto_increment fields. MD> 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 MD> brief >>explaination of the auto_increment field. MD> Do not insert any value into that column. It will be given a value MD> automagically. MD> --------------------------------------------------------------------- MD> Before posting, please check: MD> http://www.mysql.com/manual.php (the manual) MD> http://lists.mysql.com/ (the list archive) MD> To request this thread, e-mail <[EMAIL PROTECTED]> MD> To unsubscribe, e-mail <[EMAIL PROTECTED]> MD> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
