| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|#1063 - Incorrect column specifier for column 'id'|
| 2:04 pm on Apr 19, 2006 (gmt 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:
ALTER TABLE `wholesale` ADD `id` VARCHAR( 250 ) AUTO_INCREMENT FIRST
| 2:13 pm on Apr 19, 2006 (gmt 0)|
Try INT as the type instead of VARCHAR.
| 5:31 pm on Apr 19, 2006 (gmt 0)|
thanks for that :)
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved