Don Stefani wrote:
Hello,
I am trying to import a table structure from ver 3.23.52 to ver
4.1.7-max and I am getting an error:
----------- 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 'wish_list_id` int(6) NOT NULL auto_increment,
`Client_Name` varchar(255) defau' at line 2
----- end --------
I am using phpMyAdmin to do the export, and I have tried using it and
mysql> source to run the file but I get the same error from both.
You help would be appreciated.
Thanks,
- dstefani
|
Here is part of the sql file where is seems to break:
[...]
CREATE TABLE `wish_list` (
`wish_list_id` int(6) NOT NULL auto_increment,
`Client_Name` varchar(255) default NULL,
`date` date NOT NULL default '0000-00-00',
`Full_Name` varchar(200) default NULL,
`Email` varchar(255) default NULL,
[...]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]