mysql: удалить дубли — повторяющиеся строки
Удалить записи с повторящимися `photo`
в таблице `photos`
:
CREATE TABLE `photos_temp` AS (SELECT MIN(`id`) AS `id` FROM `photos` GROUP BY `photo`); ALTER TABLE `photos_temp` ADD PRIMARY KEY(`id`); DELETE FROM `photos` WHERE `id` NOT IN (SELECT `id` FROM `photos_temp`); DROP TABLE `photos_temp`;