مثلا: CREATE TABLE `images` (
`idx` BIGINT( 20 ) NOT NULL AUTO_INCREMENT ,
`added` TIMESTAMP( 14 ) NOT NULL ,
`email` VARCHAR( 150 ) DEFAULT '\'\',' NOT NULL ,
`filename` VARCHAR( 75 ) DEFAULT '\'\',' NOT NULL ,
`tn_filename` VARCHAR( 75 ) DEFAULT '\'\',' NOT NULL ,
`filepath` VARCHAR( 150 ) DEFAULT '\'\',' NOT NULL ,
`ip` VARCHAR( 25 ) DEFAULT '\'\',' NOT NULL ,
`filesize` BIGINT( 20 ) DEFAULT '\'0\',KEY `idx` (`idx`))' NOT NULL
) TYPE = MYISAM
MySQL said:
#1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key