DELETE JOIN statementMySQL provides you with the DELETE JOIN statement that allows you to remove duplicate rows quickly.
The following statement deletes duplicate rows and keeps the highest id:
SELECT * FROM products mto WHERE EXISTS ( SELECT 1 FROM products mti WHERE mti.name = mto.name ORDER BY `mto`.`name` ASC LIMIT 1, 1 ) ORDER BY `thumbnail_img` ASC
14th Feb 2018
Valentine's Day 2018 for those in relationship It's renowned for being the 'most romantic day of the year'. And many of us use it as an o
3rd Jan 2018
Official Boito Vocational Training Centre Contacts P.O. Box 91 - 20210 Litein Email: boitoyouthpolytechnic@yahoo.com Courses offered at Boito Vocational T
10th Feb 2018
-Equity Bank -Family Bank-Fidelity Commercial Bank Limited-First Community Bank-Giro Commercial Bank-Guaranty Trust Bank Kenya-Guardian Bank-ABC Bank (Ken
Comments (0)
Leave a Comment