Saturday

How To Clean Any DB Without Any Hassle



1. Dowload EM Editor https://www.emeditor.com
2. Open your .sql .txt or what shit you have with em editor
3. Go to these buttom on Em Editor
4. Click right buttom in the mouse behind these go to customize csv and in csv
5. At the top left you will see 3 modes, Separated by comas, Separated by tab or separated by users choice, click users choice and you will be able to select the separator i mean if you have "User":"Name":"Email":"Born":"Hash" you will have to put here ":" as separator or whatever im still LQ In these just put what you want to separate by, in my caise i have email:username:city:ip:hash i select : as delimiter/separator xD .
6.Now You go to start of em editor you presh users defined delimitors/separator mode and magic, your combo is splited and you can delete the info you wish.


No comments: