mysql更新30分钟内的状态数据

UPDATE o_account_recharge_order SET order_state = 4 where now() > SUBDATE(create_time,interval -30 minute) and order_state = 1

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/yangzailu/p/14102494.html