mysql 40014无效_[Err] 1064 Mysql中运行以前的SQL文件，出现以下错误。跪求大神解答...

[Err]1064-YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear'/*SQLyogEnterprise-MySQLGUIv6.0Host-5.0.45...

[Err] 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 '/*

SQLyog Enterprise - MySQL GUI v6.0

Host - 5.0.45-community-nt-log : Data' at line 1

[Err] /*

SQLyog Enterprise - MySQL GUI v6.0

Host - 5.0.45-community-nt-log : Database - cdshopdbe

*********************************************************************

Server version : 5.0.45-community-nt-log

*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `cdshopdbe`;

USE `cdshopdbe`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `admin` */

CREATE TABLE `admin` (

`admin` varchar(20) NOT NULL,

`password` varchar(20) default NULL,

PRIMARY KEY (`admin`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `admin` */

LOCK TABLES `admin` WRITE;

UNLOCK TABLES;

/*Table structure for table `cd` */

CREATE TABLE `cd` (

`cdId` int(11) NOT NULL auto_increment,

`supertype` varchar(20) NOT NULL default '',

`subtype` varchar(30) NOT NULL default '',

`country` varchar(20) NOT NULL default '',

`cdName` varchar(50) character set gb2312 collate gb2312_bin NOT NULL,

`price` float default NULL,

`nowPrice` float default NULL,

`introduce` varchar(600) character set gb2312 collate gb2312_bin default NULL,

`player` varchar(50) character set gb2312 collate gb2312_bin default NULL,

`director` varchar(50) character set gb2312 collate gb2312_bin default NULL,

`picture` varchar(50) default NULL,

`publishtime` int(11) default NULL,

`intime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

`number` int(10) default NULL,

`salenumber` int(10) default NULL,

PRIMARY KEY (`cdId`),

KEY `subtypeId` (`subtype`),

KEY `supertypeId` (`supertype`),

KEY `countryId` (`country`)

) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

/*Data for the table `cd` */

LOCK TABLES `cd` WRITE;

展开