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
Please help if you can! Thanks in advance
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`
--
Last edited by a moderator: