create table table_name ( id int not null auto_increment, primary key (id) ) auto_increment = 1001
----- Original Message ----- From: "Steve Maroney" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 28, 2001 6:59 AM Subject: [PHP] Not PHP but MYSQL > > > Sorry for the OT, but im trying to figure out something with mysql and > need some help. > > Does anyone know how set the auto_increment value to some other number > than 0. I have an order_number coloumn and I want to start it at 1000. > So the first record would 1001. > > > > > > > > > Thank you, > Steve Maroney > > > > > > -- > PHP General 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 General 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]
