Украина, Днепр
(095) 478-70-11
Показать какие есть совпадения
SELECT field, COUNT( field) as x FROM table_search_results GROUP BY field HAVING x >1;
Показать какие есть совпадения по нескольким полям
SELECT sh1.* FROM search sh INNER JOIN search sh1 ON sh.ids = sh1.ids AND sh.status = sh1.status AND sh.id <> sh1.id;
Показать общее количество совпадений
SELECT count(*) AS total_count FROM (SELECT fieldFROM table_search_results GROUP BY field HAVING COUNT(field) > 1 ) AS x;
Сохранить дубликаты в файл
mysql -u root -p name_bd -e "SELECT field, COUNT( field ) as x FROM table_search_results GROUP BY field HAVING x >1" > x.txt
Copyright © 2012-2023 All rights reserved.
created by WPS.