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