diff options
Diffstat (limited to 'examples.php')
| -rw-r--r-- | examples.php | 24 |
1 files changed, 20 insertions, 4 deletions
diff --git a/examples.php b/examples.php index 4051d60..970db0a 100644 --- a/examples.php +++ b/examples.php @@ -1,9 +1,25 @@ <?php require_once('SqlFormatter.php'); -$sql = "SELECT count(*),`Column1`,`Testing`, `Testing Three` FROM `Table1` -WHERE Column1 = 'testing' AND ( (`Column2` = `Column3` OR Column4 >= NOW()) ) -ORDER BY Column3 DESC GROUP BY Column1 LIMIT 5,10"; +$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%\"", +); -echo SqlFormatter::format($sql); +foreach($statements as $sql) { + echo "<hr />"; + echo SqlFormatter::format($sql); +} ?> |