php-mysql-engine
php-mysql-engine copied to clipboard
A MySQL engine written in pure PHP
This PR demonstrates a corner case that we use in our code, where UPDATE is used with ORDER BY. I'm not sure how to resolve it, so it's a WIP....
When `$value` is an empty string then accessing its first element (`$value[0]`) fails: ``` Uninitialized string offset: 0 ```
From MySQL perspective the `boolean` is an alias for `tinyint`.
mysql:host=mysql;port=3306;dbname=my_db is valid dsn, but does not handled correctly
The STR_TO_DATE function in MySQL was not implemented, so it was added. By specifying a string representing a date and the format of the string as an argument, it can...
This pull request improves the behaviour of the GROUP_CONCAT function in php-mysql-engine to provide MySQL-compliant aggregation. The main changes include: - Adjusting the implementation so that if a GROUP BY...
This PR implements support for INSERT ... SELECT syntax in php-mysql-engine. Previously, the engine supported INSERT ... VALUES and INSERT ... SET, but INSERT ... SELECT was not implemented. This...
Hello everyone, I’ve been using this project at my company and found a need for additional functionality, so I went ahead and implemented them. Additionally, I would like to enable...
This pull request addresses an issue within the `CreateTableParser` in php-mysql-engine where encountering a `FOREIGN KEY` constraint in a `CREATE TABLE` statement causes a parser error. The main change aims...