phpmyadmin does wrong

[galaxyAbstractor]

I want to make a table with 2 rows and 1 is auto increment. I used the phpMyAdmin UI, I didn't put any SQL in it and it says:

CREATE TABLE `test`.`gadget` ( `gcode` VARCHAR( 20000 ) NOT NULL ,
`id` VARCHAR( 20000 ) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM
MySQL sa:
#1063 - Incorrect column specifier for column 'id'

^^This is what PhpMyAdmin does after I press save^^

Is it a fault in my phpMyAdmin installation?

But if I do without auto_increment it works...

 

[scorch94]

Try INT instead of VARCHAR (most people use integers for IDs anyway).

 

[galaxyAbstractor]

Try INT instead of VARCHAR (most people use integers for IDs anyway).

INT has a limit to 255. Whatif I have more than 255 items? Wiuldn't work

 

[galaxyAbstractor]

Fixed. I just understanded it wrong. I thought if it was INT(11) it meant that number 11 was the largest number it could hold...