#1064 - You have an error in your SQL syntax;
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
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