同步a表的数据到 b表

//同步a表的数据到 b表
UPDATE a t1 JOIN b t2
ON t1.finance_id = t2.id
SET t1.a_id = t2.a_id,t1.b_name = t2.b_name,t1.ct_id = t2.c_id,t1.d_no = t2.d_no

 

//更新同一个表的状态

UPDATE table set is_invoice = 2 WHERE is_invoice=1