MsSQL: Find Foreign Key References
Found via this source, this will list all foreign key relations in the database:
WordPress: Globally update URL
In WordPress, instead of using relative URL when referring to posts, pages and images used within the site, absolute url is used. This becomes a problem if your development site …
Chive: phpMyAdmin alternative?
Update: It was announced in July 2014 that Chive is no longer actively developed and maintained. I recently discovered Chive from Yii‘s home page, one of my most frequently visited …
MySQL: Import CSV data
There are a few ways to to it. Here’s a solution using load data:
SQL: Running total
To calculate running total / balance in a single SQLÂ statment: