set id to a specified number

[Anon]

I want to create a table and set the id to 1000. Please show me the syntax because I didn't find anything in mysql documentation.

See what I am trying to do, but get not successfull.

CREATE TABLE test2 (
n1=1000 int(1) NOT NULL,
n2 tinyint(4) NOT NULL,
n3 tinyint(4) NOT NULL,
PRIMARY KEY (n1)
);

Thanks

Rod

[Anon]

Do you mean you want the default to be 1000? Then use this:

n1 INT(1) NOT NULL DEFAULT 1,

If that's not it, let me know.

---John Holmes...