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? Thanks, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] --------------------------------------------------------------------- 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
