MySQL Forums
Forum List  »  Knowledge Base

Create a Table
Posted by: Matt Wessels
Date: May 27, 2009 10:08AM

Hi

I need help on the create of a table.

The error i'v got:

SQL query:

CREATE TABLE `ncits_plw`.`users` (
`name` LONGTEXT BINARY CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FULLTEXT (
`name`
)
) ENGINE = MEMORY CHARACTER SET armscii8 COLLATE armscii8_bin

MySQL said: Documentation
#1063 - Incorrect column specifier for column 'name'

What must I correct or do

Thanx
Matt

Options: ReplyQuote


Subject
Views
Written By
Posted
Create a Table
2670
May 27, 2009 10:08AM


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.