Smashing Magazine has done it again. Their latest post, 8 Useful WordPress SQL Hacks, is a goldmine of useful tricks to streamline your WordPress experience.
The tips include
- Backing up (and restoring) your database
- Batch deleting post revisions
- Resetting a lost admin password
- Updating your database with a new domain, if you ever move to a new one
Definitely some knowledge to have your blogger’s toolbox.
If you really want to master SQL, I’d recommend reading Learning MySQL or similar book.