mysql 实用查询语句记录
1 查询某个数据库的表的记录数,并按从多到少排序
use information_schema;
select table_name,table_rows from tables where TABLE_SCHEMA = ‘wechat’ order by table_rows desc;
2 导出表结构
mysqldump -uname -p –no-data db_name > db.sql
3 导出数据库,排除某些表
mysqldump -uwechat -p dbname–ignore-table=dbname.table1–ignore-table=dbname.table2 >db_data_bak.sql;