mysql> show tables;
+--------------+
| Tables_in_ab |
+--------------+
| student |
+--------------+
1 row in set (0.00 sec)mysql> rename table student to 学生成绩表;
ERROR 7 (HY000): Error on rename of '.\ab\student.frm' to '.\ab\瀛︾敓鎴愮哗琛?f
rm' (Errcode: 22)
+--------------+
| Tables_in_ab |
+--------------+
| student |
+--------------+
1 row in set (0.00 sec)mysql> rename table student to 学生成绩表;
ERROR 7 (HY000): Error on rename of '.\ab\student.frm' to '.\ab\瀛︾敓鎴愮哗琛?f
rm' (Errcode: 22)
先set names 'gbk';
rename table student to 学生成绩表;
mysql> set names gbk;
Query OK, 0 rows affected (0.01 sec)mysql> select*from student;
+------+------+------+------+
| 名字 | 语文 | 数学 | 英语 |
+------+------+------+------+
| 张三 | 58 | 47 | 86 |
+------+------+------+------+
1 row in set (0.00 sec)mysql> rename table student to 学生成绩表;
ERROR 7 (HY000): Error on rename of '.\ab\student.frm' to '.\ab\瀛︾敓鎴愮哗琛?f
rm' (Errcode: 22)
mysql>
set names latin1;
都试试..
ERROR 7 (HY000): Error on rename of '.\ab\student.frm' to '.\ab\瀛︾敓鎴愮哗琛?f
rm' (Errcode: 22)
然后再。