[please help] sql error #1064

Lordemma

Junior Member
Joined
Jun 29, 2011
Messages
170
Reaction score
11
hell pals, can any one tell me what the hell is wrong with this sql code? I do get this error when importing the sql database
Code:
 "
[B]SQL query:[/B]     
              -- phpMyAdmin SQL Dump -- version 2.6.4-pl2 -- [URL]http://www.phpmyadmin.net[/URL] --  -- Host: localhost -- Generation Time: Apr 29, 2006 at 07:31 PM -- Server version: 4.0.25 -- PHP Version: 4.3.11 --  --   -- --------------------------------------------------------  --  -- Table structure for table `addressbook` --   CREATE TABLE `addressbook` (   `id` int(64) NOT NULL auto_increment,   `nickname` varchar(64) NOT NULL default '',   `phone` varchar(64) NOT NULL default '',   `grup` varchar(64) NOT NULL default '',   `first` varchar(64) NOT NULL default '',   `last` varchar(64) NOT NULL default '',   `email` varchar(64) NOT NULL default '',   `address` varchar(64) NOT NULL default '',   `city` varchar(64) NOT NULL default '',   `state` varchar(64) NOT NULL default '',   `zip` varchar(64) NOT NULL default '',   `home` varchar(64) NOT NULL default '',   `country` varchar(64) NOT NULL default '',   `fax` varchar(64) NOT NULL default '',   `details` varchar(64) NOT N[...]     
      [B]MySQL said: [/B][URL="http://gurushost.com:2082/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Ferror-messages-server.html&token=70103ab938cd443bcde88212c168a76a"][IMG]http://gurushost.com:2082/3rdparty/phpMyAdmin/themes/pmahomme/img/b_help.png[/IMG][/URL] 
  #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 'TYPE=MyISAM AUTO_INCREMENT=1' at line 36 "

here is the part of the code causing the error. any idea how to fix this? 

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- [URL]http://www.phpmyadmin.net[/URL]
-- 
-- Host: localhost
-- Generation Time: Apr 29, 2006 at 07:31 PM
-- Server version: 4.0.25
-- PHP Version: 4.3.11
-- 
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `addressbook`
-- 

CREATE TABLE `addressbook` (
  `id` int(64) NOT NULL auto_increment,
  `nickname` varchar(64) NOT NULL default '',
  `phone` varchar(64) NOT NULL default '',
  `grup` varchar(64) NOT NULL default '',
  `first` varchar(64) NOT NULL default '',
  `last` varchar(64) NOT NULL default '',
  `email` varchar(64) NOT NULL default '',
  `address` varchar(64) NOT NULL default '',
  `city` varchar(64) NOT NULL default '',
  `state` varchar(64) NOT NULL default '',
  `zip` varchar(64) NOT NULL default '',
  `home` varchar(64) NOT NULL default '',
  `country` varchar(64) NOT NULL default '',
  `fax` varchar(64) NOT NULL default '',
  `details` varchar(64) NOT NULL default '',
  `owner` varchar(64) NOT NULL default '',
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `addressbook`
--
Please help if you can! Thanks in advance
 
Last edited by a moderator:
try this...

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 
try this...

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

bro You mean I should replace
) TYPE=MyISAM AUTO_INCREMENT=1 ; with the code you provided above?
 
Back
Top