Jump to content

Syntax Error


yrstruly
 Share

Recommended Posts

Can somebody please tell me, what is wrong with the following code:-- Table structure for table 'mos_joomla_book'CREATE TABLE 'mos_joomla_book' ('id' INT NOT NULL AUTO_INCREMENT,'text' TEXT NOT NULL,'published' TINYINT(1) NOT NULL,PRIMARY KEY ('id') );-- Data for table 'mos_joomla_book'INSERT INTO 'mos_joomla_book' VALUES (11,'BMW 1', 1);INSERT INTO 'mos_joomla_book' VALUES (9,'Renault Kangoo', 1);INSERT INTO 'mos_joomla_book' VALUES (8,'Audi A6', 1);INSERT INTO 'mos_joomla_book' VALUES (7,'VW Golf', 1);INSERT INTO 'mos_joomla_book' VALUES (10,'Mercedes G', 1);It displays this error:ErrorSQL query:-- Table structure for table 'mos_joomla_book'CREATE TABLE 'mos_joomla_book'('id'INT NOT NULL AUTO_INCREMENT ,'text'TEXT NOT NULL ,'published'TINYINT( 1 ) NOT NULL ,PRIMARY KEY ( 'id' ));MySQL said: Documentation#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 ''mos_joomla_book' ('id' INT NOT NULL AUTO_INCREMENT,'text' TEXT NOT NULL,'' at line 1

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...