Welcome to WebmasterWorld Guest from 23.22.182.29

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)

Preferred Member

10+ Year Member

joined:Nov 2, 2005
posts:505
votes: 0


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)

Preferred Member

10+ Year Member

joined:Apr 7, 2003
posts:540
votes: 0


Try INT as the type instead of VARCHAR.

LisaB

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

Preferred Member

10+ Year Member

joined:Nov 2, 2005
posts:505
votes: 0


thanks for that :)
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members