Answer the question
In order to leave comments, you need to log in
Answer the question
In order to leave comments, you need to log in
DELETE `c1`.*
FROM `cities` AS `c1`
JOIN `cities` AS `c2` ON `c2`.`name` = `c1`.`name`
AND `c2`.`id` < `c1`.`id`
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question