5 Command line tool to validate (syntax check) SQL files.
6 Primarily for MySQL ``.sql`` files.
8 Can be used in git pre-commit hooks to catch errors.
9 Use it from your shell, offline and without any SQL server.
11 You can also use it to format SQL queries.
19 $ php-sqllint tests/files/create-missingcomma.sql
20 Checking SQL syntax of tests/files/create-missingcomma.sql
21 Line 3, col 5 at "pid": A comma or a closing bracket was expected.
22 Line 3, col 13 at "11": Unexpected beginning of statement.
23 Line 3, col 17 at "DEFAULT": Unrecognized statement type.
27 $ php-sqllint -r emacs tests/files/create-noname.sql
28 tests/files/create-noname.sql:1.12:Error: The name of the entity was expected.
29 tests/files/create-noname.sql:1.13:Error: A closing bracket was expected.
30 tests/files/create-noname.sql:1.13:Error: At least one column definition was expected.
35 $ php-sqllint --format tests/files/select-unformatted.sql
43 DATE > NOW() AND id != 0
47 You can enable ANSI coloring by passing the ``--colors`` option.
53 Does ``php-sqllint`` not detect a syntax error, or doesn't support a certain
55 Then please report a bug at `udan11/sql-parser`__.
57 __ https://github.com/udan11/sql-parser
63 - PEAR's `Console_Commandline`__
64 - `udan11's SqlParser`__, which is used by `phpMyAdmin`__
66 __ http://pear.php.net/package/Console_CommandLine
67 __ https://github.com/udan11/sql-parser
68 __ https://www.phpmyadmin.net/
71 Dependency installation
72 =======================
77 Now you can use ``./bin/php-sqllint`` without building the phar yourself.
83 You'll need `phing`__, the PHP build tool::
87 __ https://www.phing.info/
89 The result are ``.phar`` files in ``dist/`` directory that you can execute::
91 $ ./dist/php-sqllint-0.0.1.phar tests/files/create-noname.sql
92 Checking SQL syntax of tests/files/create-noname.sql
93 Line 1, col 12 at "(": The name of the entity was expected.
102 ``php-sqllint`` is licensed under the `AGPL v3`__ or later.
104 __ http://www.gnu.org/licenses/agpl.html
110 http://cweiske.de/php-sqllint.htm
112 http://git.cweiske.de/php-sqllint.git
114 Mirror: https://github.com/cweiske/php-sqllint
119 Written by Christian Weiske, cweiske@cweiske.de