Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
jason chan
31,009 PointsSo I found out I can do all lowercase with mysql workbench? is there benefits to write in all caps?
As my topic?
I can do all lowercase for mysql on workbench? is there benefit for writing in all caps?
6 Answers
Ryan Field
Courses Plus Student 21,242 PointsHi, Jason. You're correct that you can use all lower case letters in mySQL. Using caps for words like SELECT and FROM is a convention that makes it easier to tell data you are manipulating from mySQL keywords. This makes it easier for situations such as when you (or someone else looking at your code) needs to go back later to update those database calls.
Michael Perry
8,101 PointsSo far in the course our queries haven't really gotten more than a line or two. These queries can get really large and then using the capitalization convention can help a lot.
jason chan
31,009 PointsI'm good.
jason chan
31,009 Pointssince it's only me. Nash. I prefer all lowercases.
Leigh Maher
21,830 PointsIs there any way to automatically turn keywords into all caps? It's a bit of a pain having to hit the caps button before and after writing a keyword.
Magnus Rydberg
4,683 PointsIn MySQL Workbench Go to Edit > Preferences > Query Editor and check "Use Uppercase in code completion" .
Leigh Maher
21,830 PointsThanks Maguns, but that doesn't work very well for me. It seems to work for SELECT but nothing else.
Magnus Rydberg
4,683 PointsHello Leigh
I am not sure why only SELECT would work for you. For me the setting works fine but it is a but sluggish. I have to slowly type the first letters of the keyword before autocomplete catches up and suggest a keyword in capital letters.
You can read more on the setting in the link below.
Leigh Maher
21,830 PointsOk. Thanks Magnus.
Leigh Maher
21,830 PointsOk. Thanks Magnus.
jason chan
31,009 Pointsvisual studio as an IDE. I need to learn it.