How do I set up Autonum?

Nixies · #1 (**permalink**) 04-30-04, 09:59

Persently I am trying to create a table with a field in it that automatically increment, A autoNum field.

Is this possible in MySql if so could someone point me in the correct drection,

Thanks Nixies

guelphdad · #2 (**permalink**) 04-30-04, 14:05

use auto_increment.

If you want to use a higher value than 1 for your auto_increment value then either set up the table with it or use alter table to change it.

It needs to be a myisam table and not innodb table though.

Code:

create table testing(
id int primary key auto_increment,
firstname char(12),
lastname char(12)
) type=myisam
auto_increment = 34533
;

and that value is the first one that will start in your id table.

Internet Services

Web Development

Digital Marketing

Consumer Tech