php-mysql-engine icon indicating copy to clipboard operation
php-mysql-engine copied to clipboard

Handle in dsn optional dbname delimiter

Open andrew-svirin opened this issue 4 years ago • 8 comments

mysql:host=mysql;port=3306;dbname=my_db is valid dsn, but does not handled correctly

andrew-svirin avatar Oct 04 '21 09:10 andrew-svirin

add additional commits for:

  1. Add handling of command SHOW [FULL] COLUMNS FOR {table_name}
  2. Handling multiple databases for create queries, then sql is CREATE TABLE database.table and in same script is information_schema.table
  3. Fixing PDO::getAttribute() missing method

andrew-svirin avatar Oct 05 '21 11:10 andrew-svirin

Also committed:

  1. Populating server from sql text by multiline INSERT statements.

andrew-svirin avatar Oct 05 '21 13:10 andrew-svirin

Added handler for statement ALTER TABLE {table_name} AUTO_INCREMENT={N}

andrew-svirin avatar Oct 06 '21 18:10 andrew-svirin

Also want to thanks for this library. Tests speed was boosted 30 times for me, but all depends of amount of requests to database and it response speed.

andrew-svirin avatar Oct 06 '21 18:10 andrew-svirin

Thanks! Mind fixing the typo?

muglug avatar Oct 06 '21 19:10 muglug

Thanks! Mind fixing the typo? This is result of command SHOW FULL COLUMNS FROM `author`; image Do you mean to put empty string instead of select,insert,update,references ?

andrew-svirin avatar Oct 06 '21 19:10 andrew-svirin

You added an iPrivilegies vs Privileges

muglug avatar Oct 06 '21 20:10 muglug

Oh. I see. Will fix.

andrew-svirin avatar Oct 07 '21 07:10 andrew-svirin