查询
- 查询数据表的记录数：
select count(*) from database.tablename;
- 查询datetime格式的字段：
select uuid from tablename where DATE_FORMAT(add_time, '%Y-%m-%d') = ‘2017-11-06’;
select add_time from tablename where DATE_FORMAT(add_time, '%Y-%m-%d') between '2017-11-07' and '2017-11-20';
数据库导出与导入
mysqldump -hhost -uusername -ppwd databasename > dstfilename.sql
create database dbname;
source srcfilename.sql;
