Hi Ralph, Here is how I do it, which is how you suggested. Regards, Chris... #-------------------------------------------------- CREATE TABLE `test` ( `id` int(11) NOT NULL auto_increment, `browser` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ); INSERT INTO test VALUES (10000,'Start'); INSERT INTO test VALUES (10001,' Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0; CLS4)'); #----------------------------------------------------- # results # id browser # 10000 Start # 10001 Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0; CLS4) -----Original Message----- From: Ralph Guzman [mailto:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 1:01 PM To: PHP General Mailing List Cc: PHP DB Mailing List Subject: [PHP-DB] mySQL Autoincrement Field In mySQL, how do I set an auto increment field to start at a certain number-let's say 10000? Do I just insert the first record with the desired number I wish to start with? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
