#1064 - You have an error in your SQL syntax;

Avatar
  • Answered
hello dear,

when i want run my sql query in phpmyadmin , he gives me this error
"#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 TABLE `click` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`trackemail` ' at line 8 "
here is the query:

CREATE TABLE `Suppression_offer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`xxxx` int(11) NOT NULL,
`xxxxx` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1

CREATE TABLE `click` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`blabla` varchar(255) DEFAULT NULL,
`blabla` varchar(255) DEFAULT NULL,
`blabla` varchar(255) DEFAULT NULL,
`blabla` varchar(255) DEFAULT NULL,
`blabla` int(11) DEFAULT NULL,
`entered` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=latin1
Avatar
johnpaulb-imhs1
Hello, Thank you for your question regarding a 1064 error. The issue looks to be caused by the following line missing a semicolon ';' at the end:
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1
Thank you, John-Paul