Find duplicate records in MySQL
So, the task is to get duplicate records from a MySQL database. The easy way: SELECT COUNT(*), column1, column2 FROM tablename GROUP BY column1, column2 HAVING COUNT(*)>1; More complex case: shows...
// 3 matches
So, the task is to get duplicate records from a MySQL database. The easy way: SELECT COUNT(*), column1, column2 FROM tablename GROUP BY column1, column2 HAVING COUNT(*)>1; More complex case: shows...
Another (and more easy) way to change text in multiple files is to use grep: grep -lr -e 'oldtext' * | xargs sed -i 's/oldtext/newtext/g' or to use PERL: perl -p -i -e ’s/oldtext/newtext/g’ *
Just after I posted this article the second more easy solution has been found. Here it is: Find (search) and replace text from command line in multiple files (Linux) #2 When you are working on the...