PHP-SQL-Parser
PHP-SQL-Parser copied to clipboard
greenlion
A pure PHP SQL (non validating) parser w/ focus on MySQL dialect of SQL
I have version v4.5.0 When I create a WHERE statement like `WHERE s.status_id != 8 /*Pending*/` parse it then try to create it from the parse I get `"unknown [expr_type]...
Fixes CREATE TABLE with ``` `type` varchar (255) CHARACTER SET utf8 NOT NULL ``` as described in #365. Also fixes unit tests with old TestCase class.
The following query was producing UnableToCalculatePositionException, although it is a valid sql query: ```sql SELECT * FROM table1 LEFT JOIN table2 USING (id1) ```
Added in #355 support for `CHARACTER` as alias of `CHAR` data type spoils parsing of `CHARACTER SET utf8`: ```sql CREATE TABLE IF NOT EXISTS example (`type` varchar (255) CHARACTER SET...
In composer.json there's: ``` "require" : { "php" : ">=5.3.2" } ``` but there's also: ``` "require-dev" : { ... "phpunit/phpunit" : "^9.5.13", ... } ``` which produces error in...
This issue is similar to #296. That one was closed without a shared solution. I've included the vendor/autoload.php, but continue to get the error: `Fatal error: Uncaught Error: Class 'PHPSQLParser'...
The v4.4.0 parser gives incorrect results when a string contains an escaped `'` character followed by the `--` character sequence later in the string. With the last two below examples,...
I got an error with table with foreign key. I don't know what to do. `Opened database successfully name=action,value=add name=table,value=table_activites name=id,value=0 name=idName,value=id_activite DEBUG Add item. Display form SELECT * FROM...
The below code example attempts to parse a valid SQL query and re-create it. `$this->creator` and `$this->parser` are instances of the creator and parser. Upon the query being re-created, the...
The below code example attempts to parse a valid SQL query and re-create it. `$this->creator` and `$this->parser` are instances of the creator and parser. Upon the query being re-created, the...