您无法在FROM子句中指定目标表“ NAME”进行更新

您无法在FROM子句中指定目标表“ NAME”进行更新

试试这个可能对你有帮助

DELETe  FROM NAMEWHERe NAME.id NOT IN (          SELECt * FROM (    SELECt MIN(id)  FROM NAME GROUP BY col1,col2  ) AS p )