SQL code:
SET NAMES 'gb2312'
drop table if exists t_course;
create table t_course(
id int(11) not null auto_increment,
name varchar(50) default null,
primary key(id)
)ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
#set names 'gbk';
insert into t_course values (1,'java');
insert into t_course values (2,'.Net');
insert into t_course values (3,'PHP');
insert into t_course values (4,'框架');
drop table if exists t_subject;
create table t_subject(
id int(11) not null auto_increment,
name varchar(50) default null,
course_id int(11) default null,
primary key(id)
)DEFAULT CHARSET=utf8;
insert into t_subject values (1,'jsp',1);
insert into t_subject values (2,'servlet',1);
insert into t_subject values (3,'struts',1);
insert into t_subject values (4,'c#',2);
insert into t_subject values (5,'ASP.NET',2);
insert into t_subject values (6,'VB.NET',2);
insert into t_subject values (7,'php',3);
insert into t_subject values (8,'mysql',3);
insert into t_subject values (9,'hibernate框架',4);
insert into t_subject values (10,'spring框架',4);
导入正常，可是查询时全显示：
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.00 sec)
ERROR 1
