1 SELECT createTime,create_time FROM ali_ons_topic WHERE state=2 AND create_time BETWEEN '2016-07-25 14:30:00' AND '2016-07-25 15:20:28';
2 UPDATE ali_ons_topic SET create_time=createTime WHERE state=2 AND create_time BETWEEN '2016-07-25 14:30:01' AND '2016-07-25 15:20:25';

 

posted on 2016-07-26 14:52  筱筱鹿丸  阅读(9550)  评论(0编辑  收藏  举报