Keyword Priority

[ronjeremy_69]

The auto-complete feature is very nice and has the potential to make typing sql statements much easier. I would like to suggest a feature that would allow you to tweak the order (or priority) of matching keywords when you click “tab”.

A good example is probably the most common keyword used anywhere, “SELECT”. Right now, if i type “SE” in the query editor and press [TAB], “SEC_TO_TIME” appears. I've been using mysql since the late 90's and I don't think I've EVER used the SEC_TO_TIME function, but who knows someone out there might use it all the time. So a feature that would allow me to make “SELECT” the first keyword to show up when I press “SE” [TAB] would be great. Even better, I could configure it so that all i have to do is press “S” [TAB] and then “SELECT” appears.

I have accomplished this by using SQLite to delete all “S” keywords that alphabetically come before “SELECT”, but at a cost of those keywords being lost forever if i did in fact want to use [Ctrl+Enter] to see a list of choices. Posibly an additional “priority” column in the “objects” table in Keywords.db?

[Ritesh]

Nice suggestion. Let me think about it and we can start a discussion thread on how to improve the Autocomplete feature.

[ronjeremy_69]

One other thing i forgot to mention regarding the keywords, is that it looks like there is no “clause” functionality. The biggest example i can think of is the “ORDER BY” clause.

Typing “ORDE” [TAB] inserts “ORDER”, but then you have to go on and type “BY” manually. I feel the entire “ORDER BY” should be a keyword option. Correct me if I'm wrong, but I dont think “ORDER” is used anywhere in mysql without being accompanied by “BY”?

Ritesh wrote on Apr 21 2006, 08:30 PM:

Nice suggestion. Let me think about it and we can start a discussion thread on how to improve the Autocomplete feature.

awesome, thanks!

[peterlaursen]

It is no issue to insert the 'order by' into the database. You can do yourself. Common combinations could be added like 'select * from' etc..

BTW: I think user entries (priority settings, user's own keywords and phrases) should be in a seperate database file ideally …

[ronjeremy_69]

peterlaursen wrote on Apr 21 2006, 08:51 PM:

It is no issue to insert the 'order by' into the database. You can do yourself. Common combinations could be added like 'select * from' etc..

awesome, ill give it a try!

peterlaursen wrote on Apr 21 2006, 08:51 PM:

BTW: I think user entries (priority settings, user's own keywords and phrases) should be in a seperate database file ideally …

Yep i agree, so you dont have to redo it every new SQLyog version

[ronjeremy_69]

It's easy to add with SQLite, but the “COALESCE” function seems to be missing.

[peterlaursen]

Is COALESCE available with MySQL 3,23 ?

http://webyog.com/faq/8_94_en.html

[ecco]

Maybe it is hard to implement, but when in the select/from or where clause it would be nice to be able to autocomplease also the tablenames and fieldnames in the current db.

For fieldnames it is maybe nessasary to first compled the from clause.

greatings Ecco

[peterlaursen]

Well there are plans for a Visual SQL builder. I think that will do the trick …

[Author]

Posts