diff options
author | Jeremy Dorn <jeremy@jeremydorn.com> | 2012-05-06 09:58:25 -0700 |
---|---|---|
committer | Jeremy Dorn <jeremy@jeremydorn.com> | 2012-05-06 09:58:25 -0700 |
commit | 0ced5f358bc49de724cce2b0ab06a89369ed5c1e (patch) | |
tree | bfd79ef390e1c6d294e0fbf2c08b069d12b4965a /examples.php | |
parent | 1109ff5bb76077a74cedc4860e2013c5a19a73f4 (diff) | |
download | sql-formatter-0ced5f358bc49de724cce2b0ab06a89369ed5c1e.zip sql-formatter-0ced5f358bc49de724cce2b0ab06a89369ed5c1e.tar.gz sql-formatter-0ced5f358bc49de724cce2b0ab06a89369ed5c1e.tar.bz2 |
Added example output screenshot. Created examples directory.
Diffstat (limited to 'examples.php')
-rw-r--r-- | examples.php | 27 |
1 files changed, 0 insertions, 27 deletions
diff --git a/examples.php b/examples.php deleted file mode 100644 index 3478e5d..0000000 --- a/examples.php +++ /dev/null @@ -1,27 +0,0 @@ -<?php -require_once('SqlFormatter.php'); - -$statements = array( - "SELECT * FROM MyTable WHERE id = 46", - - "SELECT count(*),`Column1`,`Testing`, `Testing Three` FROM `Table1` - WHERE Column1 = 'testing' AND ( (`Column2` = `Column3` OR Column4 >= NOW()) ) - GROUP BY Column1 ORDER BY Column3 DESC LIMIT 5,10", - - "select * from `Table`, (SELECT group_concat(column1) as col FROM Table2 GROUP BY category) - Table2, Table3 where Table2.col = (Table3.col2 - `Table`.id)", - - "insert ignore into Table3 (column1, column2) VALUES ('test1','test2'), ('test3','test4');", - - "UPDATE MyTable SET name='sql', category='databases' WHERE id > '65'", - - "delete from MyTable WHERE name LIKE \"test%\"", - - "SELECT * FROM UnmatchedParens WHERE ( A = B)) AND (((Test=1)" -); - -foreach($statements as $sql) { - echo "<hr />"; - echo SqlFormatter::format($sql); -} -?> |