UPDATE $mapkey1 AS t1 SET $mapkey2 = 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$
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/deAW 著作权归作者所有。请勿转载和采集!