Francis24

Created December 30, 2016 08:43

Hello Eugene, my datasource has the database field filled. Your solution works for .sql files, but not for .php files with SQL strings in it, like the example i've post above

1. Community
2. PhpStorm
3. PHPStorm 2016.3: sql generic dialect needs database prefix to autocomplete tables and colum names

• 0 votes

Edited December 29, 2016 12:44

Hello Vladimir, Yes, i'm working with MySQL server. Most of my queries giving errors with 'mysql' dialect are on this format: $db->prepare("UPDATE mytable SET " . $ph->getParameters() . " WHERE id=...

1. Community
2. PhpStorm
3. PHPStorm 2016.3: sql generic dialect needs database prefix to autocomplete tables and colum names

• 0 votes