mysql导入汉字乱码_sql文件导入mysql出现中文乱码

我建立一sql文件，c:\school.sql,内容如下：dropdatabaseifexistsschool;createdatabaseschool;useschool;createtableteacher(idint(3)auto_incrementnotnullprimarykey,namechar(10)...

我建立一sql文件，c:\school.sql,内容如下：drop database if exists school;

create database school;

use school;

create table teacher ( id int(3) auto_increment not null primary key,

name char(10) not null,

address varchar(50) default '深圳',

year date );

insert into teacher values(null,'allen','大连一中','1976-10-10');

insert into teacher value(null,'jack','大连二中','1975-12-23');

执行mysql>source c:\school.sql出现如下内容：

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

C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe Ver 14.14 Distrib 5.1.39, for Win32 (ia32)

Connection id: 1

SSL: Not in use

Using delimiter: ;

Server version: 5.1.39-community MySQL Community Server (GPL)

Protocol version: 10

Connection: localhost via TCP/IP

Insert id: 2

Client characterset: gbk

Server characterset: gbk

TCP port: 3306

Uptime: 1 hour 2 min 20 sec

Threads: 1 Questions: 45 Slow queries: 0 Opens: 21 Flush tables: 1 Open tables: 1 Queries per

second avg: 0.12

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

ERROR:

Failed to open file 'c:chool.sql', error: 2

但若在mysql>下一步一步执行是可以的，问题是用mysql> describe teacher;中文“深圳”却无法正常显示，如下，请高手指教，谢谢

+---------+-------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+---------+-------------+------+-----+---------+----------------+

| id | int(3) | NO | PRI | NULL | auto_increment |

| name | char(10) | NO | | NULL | |

| address | varchar(50) | YES | | 深? | |

| year | date | YES | | NULL | |

+---------+-------------+------+-----+---------+----------------+

4 rows in set (0.01 sec)

谢谢回答。set names gbk; 加入SQL文件仍不行。第2个 insert 语句中的 values 漏了一个 s是提问时忘记的，原SQL文件中有。本人是新手，“跟编码的选择有关”，安装MYSQL时，有设置语言：GBK

展开