It has been ages since I needed to write MySQL queries. I barely remember the basics. I found myself perplexed after learning DELETE does not allow you to specify a limit. I thought it simply acted as a SELECT but the results instead of being returned where deleted. It seems you need to nest 2 […]
How to fix mysqldump to export emoji with the correct codification / charset using the terminal command…
All the MySQL tables have the be optimized once in a while. Ideally, once a week perhaps. You can do that by either going to your phpMyAdmin or, if you’re a badass command line user, run the following command…
If your MySQL databases uses MyISAM instead of InnoDB you should turn the last one Off. It should free memory and optimize your MySQL performance.
Select random rows from a database base with MySQL
Following yesterday’s post about Turning Off Post Revisions today I’m going to show you how to delete those revisions from the data base.