diff options
author | adityagoyal <ang.adityagoyal@yahoo.com> | 2013-06-30 15:10:52 +0530 |
---|---|---|
committer | adityagoyal <ang.adityagoyal@yahoo.com> | 2013-06-30 15:11:18 +0530 |
commit | 38a4639611d53832d63c55f6f69a6f1785cec53c (patch) | |
tree | ab8ccd495243d3536fe1c2685276b926d8de03b0 /examples/examples.php | |
parent | 6974c23faa4bbac4c85e5c8a14760b1d99182e7e (diff) | |
download | sql-formatter-38a4639611d53832d63c55f6f69a6f1785cec53c.zip sql-formatter-38a4639611d53832d63c55f6f69a6f1785cec53c.tar.gz sql-formatter-38a4639611d53832d63c55f6f69a6f1785cec53c.tar.bz2 |
Added LEFT OUTER JOIN, RIGHT OUTER JOIN in newline reserved keys.Removed XOR.
Added LEFT OUTER JOIN, RIGHT OUTER JOIN in newline reserved
keys.Removed XOR.
Added LEFT OUTER JOIN and RIGHT OUTER JOIN example for windows.
Diffstat (limited to 'examples/examples.php')
-rw-r--r-- | examples/examples.php | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/examples/examples.php b/examples/examples.php index 9d69182..97771ad 100644 --- a/examples/examples.php +++ b/examples/examples.php @@ -44,6 +44,11 @@ $statements = array( < DATE_FORMAT(NOW(), '%Y-%c-%d') ORDER BY d.id LIMIT 2,10) a, orc_scheme_detail b WHERE a.id = b.id", + "SELECT * from Table1 LEFT OUTER JOIN Table2 on Table1.id = Table2.id", + + "SELECT * from Table1 LEFT + OUTER JOIN Table2 on Table1.id = Table2.id", + "SELECT * FROM MyTable WHERE id = 46", "SELECT count(*),`Column1`,`Testing`, `Testing Three` FROM `Table1` |