summaryrefslogtreecommitdiffstats
path: root/examples/examples.php
diff options
context:
space:
mode:
authoradityagoyal <ang.adityagoyal@yahoo.com>2013-06-30 15:10:52 +0530
committeradityagoyal <ang.adityagoyal@yahoo.com>2013-06-30 15:11:18 +0530
commit38a4639611d53832d63c55f6f69a6f1785cec53c (patch)
treeab8ccd495243d3536fe1c2685276b926d8de03b0 /examples/examples.php
parent6974c23faa4bbac4c85e5c8a14760b1d99182e7e (diff)
downloadsql-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.php5
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`