Skip navigation links

MySQL Forums :: 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


Advanced Search

#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 3024 Alex Sev 02/07/2011 04:07AM
Re: #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 603 Rick James 02/08/2011 09:19AM


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.