Feature Request – Table And Column Color Coding In Query

[stuff8]

i think it would be nice to be able to color code not only the comments, strings, functions, and keywords, but also the table and column names. i don't always use autocomplete and it would be helpful to know that i've typed in actual tables and columns

[peterlaursen]

How should it be posssible if not autocomplete is enabled? Only with autocomplete enabled SQLyog can tell what identifiers (names) apply for the connection.

But with AC enabled I think the request makes sense. If I type

Code:

SELECT * FROM webyog_support.messages ORDER BY MID DESC LIMIT 20

.. then 'webyog_support.messages' and '20' are black (non-colored). 'webyog_support' is a valid database on this server and 'messages' is a valid table.

Should I instead type

Code:

SELECT * FROM support.messages ORDER BY MID DESC LIMIT 20

.. then 'support' is not a valid database identifier.

So if 'webyog_support.messages' was colored and 'support.messages' was not then user would easily see that there is a non-valid identifier in the statement having 'support.messages' only. Without AC we cannot do it – only the AC database tells what are valid identifiers for the connection (sending a bunch of SHOW statements to the server for every keystroke is not feasible of course).

It makes sense also because in both above statements 'MID' is colored as a function. But in the context MID is a column identifier ('message id'). So with with identifier coloring – and giving priority to identifiers – this would also be more clear when identifiers collide with keywords and functions.

But it will require Autocomplete!

[stuff8]

i should clarify. i do have autocomplete enabled, but i' sometimes type faster than autocomplete's ability to give me the choice i need (especially where the tags have many of its first letters being the same). so having it work with autocomplete on is fine.

actually though, autocomplete does not need to be on. one could just use the autocomplete tag file to highlight the text, but not do the other functions of autocomplete.

either way, i think it would be a nice feature.

[nithin]

Hello,

We will discuss about the feature you suggested after releasing 8.13 and will update here.

Thanks

[Author]

Posts