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