Welcome to WebmasterWorld Guest from 54.227.52.24

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

#1063 - Incorrect column specifier for column 'id'

     

jake66

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

bunltd

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

10+ Year Member



Try INT as the type instead of VARCHAR.

LisaB

jake66

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

5+ Year Member



thanks for that :)
 

Featured Threads

Hot Threads This Week

Hot Threads This Month