![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
文章平均质量分 78
L_7alone
这个作者很懒,什么都没留下…
展开
-
mysqldump备份还原和mysqldump导入导出语句大全详解
mysqldump备份还原和mysqldump导入导出语句大全详解mysqldump备份:mysqldump -u用户名 -p密码 -h主机 数据库 a -w "sql条件" --lock-all-tables > 路径案例:mysqldump -uroot -p1234 -hlocalhost db1 a -w "id in (select id from b)"转载 2015-01-29 11:07:27 · 389 阅读 · 0 评论 -
学习 MySQL中导入 导出CSV
MySQL中导出CSV格式数据的SQL语句样本如下:Sql代码 select * from test_info into outfile '/tmp/test.csv' fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by转载 2015-01-29 11:46:47 · 588 阅读 · 0 评论 -
ERROR 1 (HY000): Can't create/write to file'/' (Errcode: 13)错误解决
错误现象:mysql> select 'sz',code,time,openprice,HighPrice,LowPrice,CurPrice,TotalAmount,LastClosePrice -> into outfile '/app/hadoop/data/stocks/sz000001.txt' -> fields terminated by ','转载 2015-01-29 11:48:07 · 2825 阅读 · 0 评论