MySQL Forums
Forum List  »  Newbie

Cannot create fields in a table
Posted by: crzykle
Date: June 09, 2005 02:59AM

Hi .. i'm new to mySQL 4.0
couldnt create a table with following fields in database ...

The following error was displayed :
SQL-query :

CREATE TABLE `users` (
`username` VARCHAR( 100 ) NOT NULL AUTO_INCREMENT ,
`joined_date` DATE( 6 ) NOT NULL ,
`emailid` VARCHAR( 100 ) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `username` )
)

MySQL said:


#1063 - Incorrect column specifier for column 'username'

Can u post what my problem is???

Options: ReplyQuote


Subject
Written By
Posted
Cannot create fields in a table
June 09, 2005 02:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.