我写了个update语句
update ao_msg_suc t set t.suc_cnt = suc_cnt, t.fail_cnt = fail_cnt + null_cnt, t.suc_percent = suc_percent, t.mes_flow = suc_flow + fail_flow + null_flow where t.id = idx_id;死活找不到为什么无效,最后才发现是 列名儿和变量名儿重了~
我写了个update语句
update ao_msg_suc t set t.suc_cnt = suc_cnt, t.fail_cnt = fail_cnt + null_cnt, t.suc_percent = suc_percent, t.mes_flow = suc_flow + fail_flow + null_flow where t.id = idx_id;死活找不到为什么无效,最后才发现是 列名儿和变量名儿重了~