All caps in SQL

why are so many commands in SQL typed in all caps when they work just as well in lower case?

I am not sure there is an official rule, you might need to google that

i capitalize the (my)sql keywords, to improve readability. Then i know what are SQL keyword and what are table/column names. Which is really nice if you have more complicated queries

Writing working code and writing easy to read/understandable code are two very different things


ok, @stetim94, that makes sense.