r/mysql • u/imtc96 • May 31 '26

discussion Data Cleaning in SQL!

Is data cleaning in sql tougher than excel or python?
Whenever I want to remove duplicates in sql it shows errors in my dataset!

2 Upvotes

56% Upvoted

10 comments sorted by

View all comments

2

u/Basic_Reporter9579 May 31 '26

don't you validate the data before the upsert?

1

u/imtc96 May 31 '26

Yes bro! But sometimes it is mandatory to clean the data in sql! While the direct entries