SQL语句更新订单状态：基于时间和随机间隔
UPDATE ${map['key1']} AS t1 SET ${map['key2']} =
CASE
WHEN order_state='0-0' THEN '0-1'
WHEN order_state='2-0' THEN '2-1'
WHEN order_state='3-0' THEN '3-1'
END
WHERE t1.${map['key3']}=${map['key4']}
AND t1.order_state IN('0-0','2-0','3-0')
AND NOW() > DATE_ADD(${map['key5']} , INTERVAL FLOOR(RAND()*(30-15+1)+15) MINUTE)
原文地址: https://www.cveoy.top/t/topic/nDd6 著作权归作者所有。请勿转载和采集!