一个UTF-8编码的表Student,要导入到一个GBK编码的表中,Student表的结构下面所示:
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(10) | NO | | | |
| age | int(11) | NO | | 0 | |
| class | varchar(10) | NO | | NULL | |
+-------+-------------+------+-----+---------+----------------+
SQL语句为: