UPDATE table AS t
JOIN table AS tt
ON t.initials = tt.initials
AND t.surname = tt.surname
AND t.company = tt.company
AND t.id > tt.id
SET t.active = 1;
也就是说,对于每一行,如果存在另一行ID较低,名称首字母,姓氏和公司相同的行,则对其进行更新。
选择使用不同的mysql更新
UPDATE table AS t
JOIN table AS tt
ON t.initials = tt.initials
AND t.surname = tt.surname
AND t.company = tt.company
AND t.id > tt.id
SET t.active = 1;
也就是说,对于每一行,如果存在另一行ID较低,名称首字母,姓氏和公司相同的行,则对其进行更新。