Entries by tag: sql

Including child/synonym tags

PostgreSQL Common Operations: Reference + Examples  10 Mar 2017    postgres sql ubuntu

Common operations you may first yourself doing over and over again when dealing with PostgreSQL databases. Unless otherwise stated, examples assume version 9 or later, running on Ubuntu. Read More ›

SQL Joins: Returning Multiple Versions of a Relationship in the same Row  06 Mar 2014    sql join

Read More ›

Backing up and Dumping Mysql Databases  27 Sep 2013    sql dump backup

Read More ›

Useful Examples for Dates in SQL   02 Jul 2013    sql date db

Read More ›

Run an arbitrary SQL command from within Yii  15 Apr 2013    yii sql

Read More ›

Enable SQL logging to the screen on Yii  23 Mar 2013    yii sql logging

Read More ›

SQL Reference / Cheatsheet  12 Mar 2013    sql cheatsheet

Read More ›

SQL order by multiple fields  18 Jun 2012    sql order

Read More ›