summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMichal Čihař <michal@cihar.com>2017-01-17 17:03:14 +0100
committerMichal Čihař <michal@cihar.com>2017-01-17 17:03:14 +0100
commitf06862f070d81d4b13ad9022d3489300503850cc (patch)
treedcd7cc92a7c908860f85154f1fbda9567cc62c7c
parent2a589a36841ea92e8a90c1d8e4d2fa771fbc2be5 (diff)
downloadsql-parser-f06862f070d81d4b13ad9022d3489300503850cc.zip
sql-parser-f06862f070d81d4b13ad9022d3489300503850cc.tar.gz
sql-parser-f06862f070d81d4b13ad9022d3489300503850cc.tar.bz2
Add example for changing SQL mode
Fixes #124 Signed-off-by: Michal Čihař <michal@cihar.com>
-rw-r--r--README.md7
1 files changed, 7 insertions, 0 deletions
diff --git a/README.md b/README.md
index 88d81e5..6aebabf 100644
--- a/README.md
+++ b/README.md
@@ -77,6 +77,13 @@ $parser->statements[0]->from[0] = $table2;
$statement = $parser->statements[0];
$query2 = $statement->build();
var_dump($query2); // outputs string(19) "SELECT * FROM `b` "
+
+// Change SQL mode
+SqlParser\Context::setMode('ANSI_QUOTES');
+
+// build the query again using different quotes
+$query2 = $statement->build();
+var_dump($query2); // outputs string(19) "SELECT * FROM "b" "
```
## More information