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?
I recently discovered Chive from Yii‘s home page, one of my most frequently visited site recently since I’m currently working on a project based on Yii Framework. What is Chive? …
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: