这问题弄一下午了 还是没弄好
有没有人帮忙优化一下
UPDATE 't_order' SET money=(select CEILING(TIMESTAMPDIFF(minute,t.order_time,t.order_completion_time)/60) from t_order t) WHERE state=5
这问题弄一下午了 还是没弄好
有没有人帮忙优化一下
UPDATE 't_order' SET money=(select CEILING(TIMESTAMPDIFF(minute,t.order_time,t.order_completion_time)/60) from t_order t) WHERE state=5
UPDATE 't_order' SET money= CEILING(TIMESTAMPDIFF(minute,t.order_time,t.order_completion_time)/60) WHERE state=5