Linux清理cached 禁言 清理t_message

linux清理cachedsyncecho "1" >/proc/sys/vm/drop_cachesecho "0" >/proc/sys/vm/drop_caches禁言curl -d "checkCode=123456&type=0&videoId=22308" "http://www.url.com/v1/rest/sys/blockChat"测试后台是否正常 每次会生成游客tokencurl -d "net=3&client=2" "http://url/v2/rest/app/sys/init"在redis中查询token命令hgetall u:10011查看media idselect id,user_id,title,begin_time from t_media_asset where title like "%直播名称%";清理t_messagecreate table tmp as select max(id) as col1 from t_message_box group by receiver_id;delete from t_message_box where id not in (select col1 from tmp); drop table tmp;查看表中的记录数  select count(*) from t_user;    模糊查找  select id,telephone,score,nick_name from t_user where nick_name like '%饭饭%';  更新分数  update t_user set score=1000 where id=10;    按分数排序  select score,nick_name from t_user order by score desc limit 10; RDS无法导入数据库sed '/GTID_PURGED/N;s/,\n/,/' owl-20150805.sql | grep -iv 'set @@global' > owl1.sqlsed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' owl1.sql > owl2.sqlDELIMITER ;;create trigger shareTrigbefore update on t_sharefor each rowbeginif old.media_id is not null and old.media_id > 0thenupdate `Error: invalid_id_test` SET x=1;end if;end ;;DELIMITER ;