N
N
Ninazu2019-07-19 18:07:45
phpstorm
Ninazu, 2019-07-19 18:07:45

How to help the IDE parse a MySQL query?

The database is broken down by clients. The structure of all tables for each client is the same. How to explain to the IDE what the variable is equal to, so as not to lose autocompletion, highlighting and field validation? Maybe something like PHPDoc?
5d31dd695399e489265947.png
The only thing that comes to mind is to create another database nearby that stores the structure, and then replace its name in the finished query with a dynamic one. But I really don't like this solution, as this is an additional human factor that affects performance, unlike IDE settings and comments, which do not affect in any way.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question