Welcome to WebmasterWorld Guest from 54.147.212.98

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

#1063 - Incorrect column specifier for column 'id'

   
2:04 pm on Apr 19, 2006 (gmt 0)

5+ Year Member



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

2:13 pm on Apr 19, 2006 (gmt 0)

10+ Year Member



Try INT as the type instead of VARCHAR.

LisaB

5:31 pm on Apr 19, 2006 (gmt 0)

5+ Year Member



thanks for that :)