#1063 - Incorrect column specifier for column 'id'

[jake66]

i am trying to create a database to calculate my wholesale costs & taxes on the fly, but when i created the database i forgot to make an "id" column (i use phpmyadmin to create the tables by hand)

all other fields were created successfully, but i keep getting this blasted error.

here's what i'm trying to do:
Field: id
Type: VARCHAR
Length/Values*: 250
Attributes: (empty)
Null: null
Default**: (empty)
Extra: auto_increment

SQL Query:
ALTER TABLE `wholesale` ADD `id` VARCHAR( 250 ) AUTO_INCREMENT FIRST

[bunltd]

Try INT as the type instead of VARCHAR.

LisaB

[jake66]

thanks for that :)