CREATE TABLE animals (

??? grp ENUM('fish','mammal','bird') NOT NULL,

??? id MEDIUMINT NOT NULL AUTO_INCREMENT,

??? name CHAR(30) NOT NULL,

??? PRIMARY KEY (grp,id)

);

ALTER TABLE tbl AUTO_INCREMENT = 1000000;


CREATE TABLE animals (

??? grp ENUM('fish','mammal','bird') NOT NULL,

??? id MEDIUMINT NOT NULL AUTO_INCREMENT,

??? name CHAR(30) NOT NULL,

??? PRIMARY KEY (grp,id)

)AUTO_INCREMENT = 1000000;