MySQL导入导出数据相关操作

导出

mysqldump -uroot -ppwd --databases data_statistic  > ./data_stat.sql

导入

mysql> source ./data_stat.sql;

导出部分数据

mysql -hip(db) -Pport -uuser -ppwd -Ddbname -e "select cbid from tablename where id=709" > ./709.txt

 

//如何复制表数据并改值//

1, 复制表结构

create table btagtmp as select * from book_tag_info where platform=15;

2，改值

update btagtmp set platform=17;

3，写回

 insert into book_tag_info select * from btagtmp;

4，查看

select * from book_tag_info where tag_id=20100001;