summaryrefslogtreecommitdiffstats
path: root/software/sql.page
blob: c485133f6c8f68680a799e0ddd01b987ad2ffb3a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
---
format: md
toc: no
...

# SQL

### MySQL-specific Tricks

To output in tab-delimited format, do something like:

    mysql -u root -p -B < some_command.sql > output.tab

### UPDATE with JOIN

To do an update based on a join::

    UPDATE tableOne t1 INNER JOIN tableTwo t2 ON t1.fk_two = t2.id SET t1.has_two = 1 WHERE t2.is_good = 1;

### JOINs

Useful visual summary: http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins