I need a query that will insert multiple records into a table but if exists, update the column labeled status for each row.
ON DUPLICATE KEY UPDATE is the solution to this problem but what if I have more than one row? ON DUPLICATE KEY UPDATE is only updating 1 of 2 rows.
For example, I want to insert table A into table B which works fine but if there's an update to the status column on table A, i want to update the status column for each row on table B.
Table A
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…