How to Removed duplicate Rows From Table in MySQL | MySQL | DELETE JOIN statement

Опубликовано: 09 Октябрь 2024
на канале: Nasir Soft
15,202
79

If You Have any Question ! Click on the Bellow Link and in Comment section , Ask your Question ?

Question Link: https://nasirsoft.com/single_video/7

------------------------------------Query -----------------------------------------
DELETE t1 FROM tweets_data_rapidminer t1
INNER JOIN tweets_data_rapidminer t2
WHERE t1.id (less than sign) t2.id AND t1.text = t2.text


--------------------------------------References ----------------------------------------------------------
https://www.mysqltutorial.org/mysql-d...


--------------------------------------Other Useful Links--------------------------------------------------------
Facebook:   / nasirsoft93  
Website : https://nasirsoft.com/
LinkedIn :   / muhammad-nasir-6b82379b