的值。

UPDATE table_name SET commission_status = 1, actual_commission_balance = commission_balance WHERE invite_user_id IS NOT NULL AND status IN (3, 4) AND type = 1 AND commission_status = 0;

当表1中invite_user_id不为null时,status等于3和4,type为1时,将commission_status等于0的值修改为1,并将actual_commission_balance等于commission_balance

原文地址: https://www.cveoy.top/t/topic/wZi 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录