莫名其妙的语法错，实在是找不到错误

[lsmiler]

source mysql.sql;是提示
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near '﨏' at lin
e 1
mysql.sql：

CREATE DATABASE Archives;
USE Archives;
CREATE TABLE lendlist (
id int(4) auto_increment NOT NULL PRIMARY KEY,
archive int(4) NOT NULL ,
borrower varchar(50) ,
lender varchar(50) ,
outtime varchar(50) ,
backtime varchar(50) ,
cause blob ,
status int(4) NOT NULL
);
CREATE TABLE department (
name varchar(50) NOT NULL PRIMARY KEY,
description blob
);
CREATE TABLE archiveset (
title varchar(50) NOT NULL PRIMARY KEY,
admin varchar(50) ,
description blob
);
CREATE TABLE archive (
id int(4) auto_increment NOT NULL PRIMARY KEY ,
title varchar(50) ,
sectionname varchar(50) ,
yeardate int(4) NULL,
period int(4) NULL,
status int(4) NOT NULL ,
archiveset varchar(50) ,
description blob ,
creater varchar(50) ,
creatingtime datetime NULL
);
CREATE TABLE infos (
id int(4) auto_increment NOT NULL PRIMARY KEY ,
sender varchar(50) ,
receiver varchar(50) ,
content blob ,
status int(4) NOT NULL
);
CREATE TABLE logging (
id int(4) auto_increment NOT NULL PRIMARY KEY,
dealer varchar(50),
dealing blob ,
tablename varchar(50)
);
CREATE TABLE member (
mem varchar (50) NOT NULL PRIMARY KEY,
pwd varchar (50) ,
priority int(4) NOT NULL,
sectionname varchar(50)
);

[julise]

你的mysql.sql文件里面的第一句,虽然可能是空的,但是他里面的编码格式,让mysql不能确认,所以,你可以把文字内容再拷到一个新建文件里试一下.

[xiaoguanguan]

我认为有可能是mysql的版本问题。就是你在低版本的mysql里生成了source.sql，然后在较高版本的mysql里再调用这个文件时，有可能会出问题。解决办法是根据提示，把那个source.sql文件里出错的那部分去掉，然后手工加上。