MySQL Forums
Forum List  »  Newbie

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 'PK' at line 1
Posted by: suha t
Date: November 05, 2013 07:38AM

CREATE TABLE IF NOT EXISTS `{$installer->getTable('slideshowimportexport_importdata')}` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`entity` VARCHAR(50) NOT NULL,
`behavior` SET('" . Esl_Slideshowimportexport_Model_Import::BEHAVIOR_APPEND. "','"
. Esl_Slideshowimportexport_Model_Import::BEHAVIOR_REPLACE . "','" .
Esl_Slideshowimportexport_Model_Import::BEHAVIOR_DELETE . "') NOT NULL DEFAULT '" .
Esl_Slideshowimportexport_Model_Import::BEHAVIOR_APPEND . "',
`data` MEDIUMTEXT NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
ROW_FORMAT=DEFAULT
");










it get #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 '")' at line 11 error plz give immediate reply ,..........................

Options: ReplyQuote


Subject
Written By
Posted
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 'PK' at line 1
November 05, 2013 07:38AM


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.