Home / Database Structure / Tables / Question No: 59

The value can be set with CREATE TABLE or ALTER TABLE statements like this:

CREATE TABLE `table_name` 
(`col_id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`col_name` VARCHAR( 19 ) NOT NULL) 
AUTO_INCREMENT = 101 ENGINE=MYISAM;

or

ALTER TABLE table_name AUTO_INCREMENT = 101;