一、如何复制cmd内容
1.右键-标记,之后就可以鼠标左键选择要复制的内容(选中后背景是白色),松开鼠标,单击右键,你选的内容已经可以-粘贴了。
2.mysql导出数据,example如下:
mysql> select * into outfile 'D:\\Mysql\\backup\\test.txt'
-> fields terminated by ',' optionally enclosed by '"'
-> lines terminated by '\r\n'
-> from userinfo;
Query OK, 27 rows affected (0.00 sec)
注意事项
a.路径要使用双斜杠.
b.MYSQL导出数据出现The MySQL server is running with the --secure-file-priv option so it cannot execute this错误。
请参考:http://blog.csdn.net/man_to_home/article/details/54947518