您的示例是SQL Server语法,而不是MySQL。
试试:
UPDATE new_leads_test2 t1 INNER JOIN new_leads_test2 t2 ON (t1.PHONE1 = t2.PHONE1 AND t1.ID > t2.ID) SET t1.duplicate = t2.ID
