I'd like to see a more advanced auto complete in SQLyog. For instance, if your sql statement is

select a.* , b.* from a_table a, b_table b where a.column_name = b.column_name

I'd like to have an auto complete in the where clause when I type in the table alias. a. or b. for the table.


I think this would be very helpful, especially for large sql statements.

Thanks!

You are right that support for alias in autocomplete is missing. When columns and other object have 'weird' names (what is often the case with big 'live' databases) it would be very nice. You are not the first one pointing to that.

However we will then need to parse the content of the editor (in real time) to identify the alias names used in the context and probably store in a (MEMORY type would work) sqlite database.
Optimally we should only autocomplete aliases for each individual statement. So it raises some architectural issues that are not very simple!


We have allready recorded this in our TODO, but not scheduled it yet.