diff options
author | Michal Čihař <michal@cihar.com> | 2017-01-17 17:03:14 +0100 |
---|---|---|
committer | Michal Čihař <michal@cihar.com> | 2017-01-17 17:03:14 +0100 |
commit | f06862f070d81d4b13ad9022d3489300503850cc (patch) | |
tree | dcd7cc92a7c908860f85154f1fbda9567cc62c7c | |
parent | 2a589a36841ea92e8a90c1d8e4d2fa771fbc2be5 (diff) | |
download | sql-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.md | 7 |
1 files changed, 7 insertions, 0 deletions
@@ -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 |