MySQL

Error #1064

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2008

Posts: 2

Reputation: anuragg21 is an unknown quantity at this point

Solved Threads: 0

anuragg21

Offline

Newbie Poster

Error #1064

Jan 3rd, 2009

While i was importing .sql file in my database i got this error #1064.

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
#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 IF NOT EXISTS `att_poll_log` (
`id` INT(10) UNSIGNED NOT NULL au' at line 4
 
#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 IF NOT EXISTS `att_poll_log` (
`id` int(10) unsigned NOT NULL au' at line 4

The actual code written in .sql file is:

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
CREATE TABLE IF NOT EXISTS `att_poll_log` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `news_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `member` VARCHAR(30) NOT NULL DEFAULT '',
  PRIMARY KEY  (`id`),
  KEY `news_id` (`news_id`,`member`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=19 ;
CREATE TABLE IF NOT EXISTS `att_poll_log` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `news_id` int(10) unsigned NOT NULL default '0',
  `member` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `news_id` (`news_id`,`member`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=19 ;

Please help this out.

Last edited by anuragg21; Jan 3rd, 2009 at 4:42 pm.

•

Join Date: Jan 2007

Posts: 276

Reputation: kanaku is on a distinguished road

Solved Threads: 15

kanaku

Offline

Posting Whiz in Training

Re: Error #1064

Jan 4th, 2009

Hallu! this page says something about reserved words being used in your query. It also says that this is sometimes caused by a mySQL version mismatch and provides a tip for exporting your database using phpMyAdmin to prevent this error.

Their link to reserved words is outdated. Try this one.

If you know ASP, you can save other daniweb members from idiots like me by helping out in this forum.

Visit this thread if your username starts with one of the following letters: B D F H J L N P R T X Y Z.