1.导出带条件的数据库
mysqldump -uroot -p123456 meteo sdata --where=" sensorid=11 and fieldid=0" > /home/xyx/Temp.sql
2.导出全部mysql
mysqldump -h rm-bp1n33078j60g4h06.mysql.rds.aliyuncs.com -u yysc -pNiao18_Wifi22 yysc user_info> test.sql
3.只导出表结构
mysqldump -h rm-bp1n33078j60g4h06.mysql.rds.aliyuncs.com -uyysc -pNiao18_Wifi22 -d yysc > yysc.sql
4.导入数据库
source /Library/www/test.sql;
5.将导出的线上文件下载到本地
scp work@121.199.68.247:/test.sql /Library/www/app/
6.mysql删除字段
ALTER TABLE table_name DROP field_name;
7.mysql添加字段
alter table user_perday_task add today_income int(11) NOT NULL DEFAULT '0' COMMENT '今日收入-金币';
8.mysql修改字段
ALTER TABLE testyysc.user_exchange
CHANGE COLUMN type type enum('reg','newtask','perdaytask','drawcash','invite','admin','open_permission','open_push') NOT NULL;
9.mysql分组查询
查询金币乐园每日领奖次数
select from_unixtime(created_at , "%Y-%m-%d") as date,sum(price) from game_order_data where status = 1 and created_at >= 1556640000 group by date;