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
8th Mar 2022
Online Point Of Sale Kenya List of best Online Point Of Sale in Kenya Point of Sale Features: Direct interface with General Ledger Maintain and
27th Aug 2021
New TSC PaySlip And Salary For a Newly Employed Teachers A graduate teacher falls under job group K which is currently referred to as grade C2 designated
21st Feb 2018
Best relationship quotes 2018 A day without you in my life should never come and even if it does, let it be the last. Loving you is the best thing that
Comments (0)
Leave a Comment