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

Databases SQL Basics Getting Data from a Database Your First SQL Statement

Michael Pashkov
Michael Pashkov
22,024 Points
Posted by Michael Pashkov
Michael Pashkov
22,024 Points

Hi guys, should I write keywords in upper case or there is no differens?

Hi guys, should I write keywords in upper case or there is no differens? For example, SELECT * FROM books; or select * from books;

2 Answers

Jonathan Grieve
MOD
Jonathan Grieve
Treehouse Moderator 91,252 Points
Jonathan Grieve
Jonathan Grieve
Treehouse Moderator 91,252 Points

Generally, it doesn't make a difference to the way it works technically, but the keywords are better to be typed in uppercase for readability sake. You'll want to be able to differentiate between different parts of your statements easily when you go back to edit or read them. :-)

Codi Hasbrouck
Codi Hasbrouck
41 Points
Codi Hasbrouck
Codi Hasbrouck
41 Points

I'm not sure, like if a table column is written in - in lowercase. Why can't I type column is always distinguishable in lowercase. Well, uh is this syntax both ways where case doesn't matter. Is case a one to one function. I'm sure the video will point this out. Ya. I just want to have that bullet point answer.