MySQL Forums
Forum List  »  InnoDB

#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
Posted by: Alex Sev
Date: February 07, 2011 04:07AM

When trying to add the table I get this error


*************THIS IS THE CODE I AM ADDING****************

--
-- Table structure for table `user_board`
--

CREATE TABLE /*$wgDBprefix*/user_board (
`ub_id` int(11) PRIMARY KEY auto_increment,
`ub_user_id` int(11) NOT NULL default '0',
`ub_user_name` varchar(255) NOT NULL default '',
`ub_user_id_from` int(11) NOT NULL default '0',
`ub_user_name_from` varchar(255) NOT NULL default '',
`ub_message` text NOT NULL,
`ub_type` int(5) default '0',
`ub_date` datetime default NULL
) DEFAULT CHARSET=utf8;
CREATE INDEX /*i*/ub_user_id ON /*_*/user_board (ub_user_id),
CREATE INDEX /*i*/ub_user_id_from ON /*_*/user_board (ub_user_id_from),
CREATE INDEX /*i*/ub_type ON /*_*/user_board (ub_type)


*****************THIS IS THE ERROR I AM GETTING**********************

Error
SQL query:

CREATE INDEX /*i*/ub_user_id ON /*_*/user_board(

ub_user_id
),
CREATE INDEX /*i*/ub_user_id_from ON /*_*/user_board(
ub_user_id_from
),
CREATE INDEX /*i*/ub_type ON /*_*/user_board(
ub_type
)
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 '
CREATE INDEX ub_user_id_from ON user_board (ub_user_id_from),
CREATE INDEX ub' at line 1



Edited 1 time(s). Last edit at 02/07/2011 04:14AM by Alex Sev.

Options: ReplyQuote


Subject
Views
Written By
Posted
#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
4898
February 07, 2011 04:07AM


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.