Demirchyan Oganes-AOD098 wrote: > Hello everyone, > > I wanted to ask you 2 questions. > > 1. I have a table that has 2 columns, user_id, user_name. > User_id has been setup to a default value 1000 and to AUTO_INCREMENT. > > When I insert a record, Insert Into User_Table (user_id,user_name) Values (Null,'Jon >Doe'); > I get 1 John Doe. But I'm expecting something like 1000 John Doe. And when I do >another insert, then it will be 1001. Why this Default Value definition not making >sure that I start with 1000?
The documentation or FAQ found on mysql.com should answer how to get your auto_increment column to start at a value other than 1. b. --------------------------------------------------------------------- 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