default value for autoincrement primary key

clem_c_rock · #1 (**permalink**) 08-18-04, 15:11

Hello,

I am trying to set up a table where the default value for the primary key starts @ 101 and auto increments from there.

I've had no luck so far. Is this possible?

-Clem C

Pat Phelan · #2 (**permalink**) 08-18-04, 21:01

See SET INSERT_ID for details.

-PatP

r937 · #3 (**permalink**) 08-18-04, 23:07

or

CREATE TABLE foo ( column definitions ) AUTO_INCREMENT=101

Pat Phelan · #4 (**permalink**) 08-19-04, 05:07

Quote:

Originally Posted by r937

CREATE TABLE foo ( column definitions ) AUTO_INCREMENT=101

I never realized you could do that! I learned something, now I can go home.

-PatP

Internet Services

Web Development

Digital Marketing

Consumer Tech