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 ,..........................
Subject
Written By
Posted
September 28, 2013 01:19AM
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
November 05, 2013 10:28PM
November 05, 2013 12:40PM
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.