Click to See Complete Forum and Search --> : Help - Error #1064- You have an error in your SQL syntax


dodo.mafia
09-20-2008, 08:49 AM
Hi,
I am using Wamp on my own computer.

when I tried to run this SQL query :

CREATE TABLE `feedback` (

`message_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 50 ) NOT NULL ,
`email` VARCHAR( 100 ) NOT NULL ,
`comments` TEXT NOT NULL ,
`interests` SET( See text ) NULL ,
`visited` VARCHAR( 50 ) NOT NULL ,
`views` SET( See text ) NULL ,
`subscribe` ENUM( 'y', 'n' ) NOT NULL ,
`submitted` TIMESTAMP NOT NULL ,
PRIMARY KEY ( `message_id` )
) ENGINE = MYISAM

A error Come:
MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'See text ) NULL ,
`visited` VARCHAR( 50 ) NOT NULL ,
`views` SET( See text ) N' at line 7

Colud any one helps me ??

NogDog
09-20-2008, 09:01 AM
The values (in the parentheses) for a SET type should be a comma-separated list of values, e.g.:

`interests` SET('PHP', 'MySQL', 'web development') NULL,

dodo.mafia
09-20-2008, 09:11 AM
Thank u very much..