Cheatography
https://cheatography.com
Because I never recall how to write anything after "UPDATE".
SELECT ... JOIN ... WHERESELECT
| a.COL1
| AS 'a1',
| | a.COL2
| AS 'a2',
| | c.COL1
| AS 'c1'
| FROM
| TBL1 a
| (WHATEVER) JOIN
| TBL2 b
| ON b.X = a.Y
| (WHATEVER) JOIN
| TBL3 c
| ON c.K = b.K
| WHERE
| a.K = b.K
| AND
| c.Z = 'foobar'
| GROUP BY
| a.COL1,
| -- basically specify | | a.COL2,
| -- all selected columns | | c.COL1
| -- when "GROUP BY" | ORDER BY
| b.Q
|
("sub-query")WHERE
| COL1 IN (
| | SELECT
| COL1
| | FROM
| TBL337 x
| | (WHATEVER) JOIN
| ...
| | WHERE
| x.Z = 'sub'
| | )
|
| | CTEWITH
| TEMP
| AS (
| | SELECT
| foo
| | FROM
| tbl1
| | UNION ALL
| | SELECT
| b.foo
| | FROM
| TEMP a
| | INNER JOIN
| tbl1 b
| | ON
| b.foo
| = a.foo
| )
| SELECT
| *
| FROM
| TEMP
| OPTION
| (MAXRECURSION 5)
|
UPDATE ... JOIN ... WHEREUPDATE
| TBL1
| SET
| COL1 = 'GOD',
| | COL2 = 'AWFUL'
| FROM
| TBL1 a
| (WHATEVER) JOIN
| TBL2 b
| ON b.X = a.Y
| WHERE
| b.Q
| IN ('bull', 'shit')
|
|
Created By
https://twitter.com/yuptogun
https://twitter.com/yuptogun
Metadata
Comments
No comments yet. Add yours below!
Add a Comment
Related Cheat Sheets