diff options
| author | Jeremy Dorn <jeremy@jeremydorn.com> | 2013-07-11 06:48:17 -0700 |
|---|---|---|
| committer | Jeremy Dorn <jeremy@jeremydorn.com> | 2013-07-11 06:48:17 -0700 |
| commit | e1aa999f64b222bdd990be6408f832c616ac57cf (patch) | |
| tree | 3bdebc81d1d207d1d0ac5b0225afca12489a80fc /examples/examples.php | |
| parent | 7dc6794a53571d5ccbe10716d20e2e3a7101c00c (diff) | |
| download | sql-formatter-e1aa999f64b222bdd990be6408f832c616ac57cf.zip sql-formatter-e1aa999f64b222bdd990be6408f832c616ac57cf.tar.gz sql-formatter-e1aa999f64b222bdd990be6408f832c616ac57cf.tar.bz2 | |
Formatting and naming changes in order to merge @adityagoyal pull request.
Diffstat (limited to 'examples/examples.php')
| -rw-r--r-- | examples/examples.php | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/examples/examples.php b/examples/examples.php index 97771ad..f54cfb0 100644 --- a/examples/examples.php +++ b/examples/examples.php @@ -43,15 +43,13 @@ $statements = array( DATE_FORMAT((DATE_SUB(NOW(),INTERVAL 1 DAY)),'%Y-%c-%d') AND t_create < 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` + "SELECT count(*),`Column1` as count,`Testing`, `Testing Three` FROM `Table1` WHERE Column1 = 'testing' AND ( (`Column2` = `Column3` OR Column4 >= NOW()) ) GROUP BY Column1 ORDER BY Column3 DESC LIMIT 5,10", |