Re: Cannot create fields in a table

[Felix Geerinckx]

crzykle wrote:

> 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'

You cannot have AUTO_INCREMENT on a VARCHAR.

--
felix
Please use BBCode to format your messages in this forum.