Skip navigation links

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


Advanced Search

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
#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 sam sanders 09/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 suha t 11/05/2013 07:38AM
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 Rick James 11/05/2013 10:28PM
Suha, please do not hijack threads Peter Brawley 11/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.