岁数大了，QQ也不闪了，微信也不响了，电话也不来了，但是图老师依旧坚持为大家推荐最精彩的内容，下面为大家精心准备的MySQL 5.1的中文支持的一个改进，希望大家看完后能赶快学习起来。
【 tulaoshi.com - 编程语言 】
MySQL 5.1的中文支持的一个改进,从MySQL 4.1开始不支持中文路径，文件名的问题解决了。
（本文来源于图老师网站，更多请访问http://www.tulaoshi.com/bianchengyuyan/）见下面示例
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:Documents and SettingsAdministratorrunas /user:aaa cmd
输入 aaa 的密码:
试图将 cmd 作为用户 "MY-TOMATOaaa" 启动...
C:Documents and SettingsAdministratorcd mysql51bin
C:mysql51binmysql -u rootWelcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 1 to server version: 5.1.7-beta-community（本文来源于图老师网站，更多请访问http://www.tulaoshi.com/bianchengyuyan/）
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql use testDatabase changedmysql show tables;+----------------+| Tables_in_test |+----------------+| tr || trb3 |+----------------+2 rows in set (0.00 sec)
mysql desc tr;+-----------+-------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+-----------+-------------+------+-----+---------+-------+| id | int(11) | YES | | NULL | || name | varchar(50) | YES | | NULL | || purchased | date | YES | | NULL | |+-----------+-------------+------+-----+---------+-------+3 rows in set (0.00 sec)
mysql insert into tr (id,name) values(1,'EWR'),(2,'SR'),(3,'GH');Query OK, 3 rows affected (0.00 sec)Records: 3 Duplicates: 0 Warnings: 0
mysql select * from tr into outfile 'c:/mysql51/猪八戒.txt';Query OK, 11 rows affected (0.00 sec)
mysql select * from tr into outfile 'c:/mysql51/新建文件夹/猪八戒.txt';Query OK, 11 rows affected (0.02 sec)
mysql create table tr2 as select * from tr limit 0;Query OK, 0 rows affected (0.06 sec)Records: 0 Duplicates: 0 Warnings: 0
mysql select * from tr2;Empty set (0.00 sec)
mysql load data infile 'c:/mysql51/新建文件夹/猪八戒.txt' into table tr2;Query OK, 11 rows affected (0.00 sec)Records: 11 Deleted: 0 Skipped: 0 Warnings: 0
mysqlC:mysql51binmysqladmin -u root shutdown
C:mysql51bincd mysql50bin
C:mysql50binmysql -u rootWelcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 1 to server version: 5.0.18
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql use testDatabase changedmysql CREATE TABLE tr (id INT, name VARCHAR(50), purchased DATE) - ;Query OK, 0 rows affected (0.05 sec)
mysql load data infile 'c:/mysql51/新建文件夹/猪八戒.txt' into table tr;ERROR 29 (HY000): File 'c:mysql51脨脗陆篓脦脛录镁录脨脰铆掳脣陆盲.txt' not found (Errcode: 2)mysql
来源:http://www.tulaoshi.com/n/20160219/1615692.html
看过《MySQL 5.1的中文支持的一个改进》的人还看了以下文章 更多>>
