Keyword Priority

This topic is empty.

Viewing 7 reply threads

Author

Posts
- April 21, 2006 at 8:30 pm #21306
  
  Ritesh
  Member
  
  Nice suggestion. Let me think about it and we can start a discussion thread on how to improve the Autocomplete feature.
- April 21, 2006 at 8:41 pm #21307
  
  ronjeremy_69
  Participant
  
  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!
- April 21, 2006 at 8:51 pm #21308
  
  peterlaursen
  Participant
  
  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 …
- April 21, 2006 at 9:03 pm #21309
  
  ronjeremy_69
  Participant
  
  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
- April 22, 2006 at 2:03 pm #21310
  
  ronjeremy_69
  Participant
  
  It's easy to add with SQLite, but the “COALESCE” function seems to be missing.
- April 22, 2006 at 6:50 pm #21311
  
  peterlaursen
  Participant
  
  Is COALESCE available with MySQL 3,23 ?
  
  http://webyog.com/faq/8_94_en.html
- April 24, 2006 at 8:03 pm #21312
  
  ecco
  Member
  
  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
- April 24, 2006 at 8:16 pm #21313
  
  peterlaursen
  Participant
  
  Well there are plans for a Visual SQL builder. I think that will do the trick …
Author

Posts