Hi again,
I would like to have lower case/upper case switcher in the Auto Complete settings.
I always used to type "SELECT field1, field2 FROM table WHERE field1>0 ORDER BY field1"
(SQL statements UPPER CASE) because it is better readable but now on outo completion SQLyog changes all the keywords to lower case...
Full Version: Suggestion: Upper Case Sql Keywords
hmmm ...
I agree that UPPERCASE KEYWORDS in SQL generally makes things more readable.
Wasn't it simpler just to have the keywords.db containing KEYWORDS in UPPERCASE?
I am not sure what to think about FuNcTiOnS ....
But I would not mind a setting ...
You can convert keywords in the database to UPPERCASE with the SQLite command line client, just execute:
.. what I would suggest was done with next release :-)
Note that if you have added your own KEYWORDS (with LOWERCASES) containing non-ASCII characters, it won't work on those!
I agree that UPPERCASE KEYWORDS in SQL generally makes things more readable.
Wasn't it simpler just to have the keywords.db containing KEYWORDS in UPPERCASE?
I am not sure what to think about FuNcTiOnS ....
But I would not mind a setting ...
You can convert keywords in the database to UPPERCASE with the SQLite command line client, just execute:
CODE
Update objects set object_name = UPPER(object_name) where object_type = 1;
.. what I would suggest was done with next release :-)
Note that if you have added your own KEYWORDS (with LOWERCASES) containing non-ASCII characters, it won't work on those!
Interesting request. I will discuss it with my developers now and update this thread in sometime.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.