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';