mysql 常用命令

导出某一列 到一个文件
SELECT content FROM article_readapp WHERE `url` LIKE ‘%36kr%’ into outfile ‘/var/lib/mysql-files/36kr.txt’ lines terminated by ‘\r\n’;

备份table
mysqldump -u root -p superplan apple_store_more > apple_store_more.sql

Leave a Reply

Your email address will not be published. Required fields are marked *