List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 25 2000 10:02pm
Subject:Re: setting default for INT
View as plain text  
At 2:36 PM -0700 2000-02-25, Erik Boles wrote:
>I have a table with a memberid field, the field is set as primary 
>key as well as auto_increment, the problem is, I don't want the 
>member numbers to start at 0 or 1, I want them to start at 1000.
>
>I have tried the following command
>
>ALTER TABLE table_name MODIFY member_id INT UNSIGNED NOT NULL 
>AUTO_INCREMENT DEFAULT "1000"
>
>It accepts this statement without error, but when I do a DESCRIBE 
>table_name it still shows the default as 0.
>
>Is there a way to change this?


a) Why is that a problem?

b) What do you want it to show instead?

c) If you want to use an AUTO_INCREMENT column, why are you trying to
set any default at all?

d) Don't you really mean ALTER TABLE table_name AUTO_INCREMENT = 1000 :-)


-- 
Paul DuBois, paul@stripped
Thread
setting default for INTErik Boles26 Feb
  • Re: setting default for INTPaul DuBois26 Feb