MySQL5.1的中文支持的一个改进


 MySQL 5.1的中文支持的一个改进,从MySQL 4.1开始不支持中文路径,文件名的问题解决了。

  见下面示例

  Microsoft Windows XP [版本 5.1.2600]

  (C) 版权所有 1985-2001 Microsoft Corp.

  C:\Documents and Settings\Administrator>runas /user:aaa cmd

  输入 aaa 的密码:

  试图将 cmd 作为用户 "MY-TOMATO\aaa" 启动...

  C:\Documents and Settings\Administrator>cd \mysql51\bin

  C:\mysql51\bin>mysql -u root
  Welcome to the MySQL monitor. Commands end with ; or \g.
  Your MySQL connection id is 1 to server version: 5.1.7-beta-community

  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

  mysql> use test
  Database changed
  mysql> 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

  mysql>
  C:\mysql51\bin>mysqladmin -u root shutdown

  C:\mysql51\bin>cd \mysql50\bin

  C:\mysql50\bin>mysql -u root
  Welcome 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 test
  Database changed
  mysql> 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 fo
  und (Errcode: 2)
  mysql>

 

本文作者:



相关阅读:
基于jQuery的的一个隔行变色,鼠标移动变色的小插件
php递归列出所有文件和目录的代码
客户端备份和恢复MSSQL Server数据库
fromCharCode和charCodeAt 方法
网络通讯--uuname
CSS样式表中的position属性详细说明
VSFTP配置实例
源码学习:一个简单的日历控件(8)
DEDECMS后台:Fatal error:Call to a member function read()
MySQL替代Oracle 技术支持成问题
快速理解Oracle归档模式的命令及参数
SQL Server 数据挖掘在商业智能中的应用
PHP 执行系统外部命令 system() exec() passthru()
Linux下取得UUID的方法分享
快速导航

Copyright © 2016 phpStudy |