homepage Welcome to WebmasterWorld Guest from 54.161.246.212
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
#1063 - Incorrect column specifier for column 'id'
jake66

5+ Year Member



 
Msg#: 12572 posted 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:
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

10+ Year Member



 
Msg#: 12572 posted 2:13 pm on Apr 19, 2006 (gmt 0)

Try INT as the type instead of VARCHAR.

LisaB

jake66

5+ Year Member



 
Msg#: 12572 posted 5:31 pm on Apr 19, 2006 (gmt 0)

thanks for that :)

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved