Below is a basic query command, selecting 3 columns (name, genre, year) from the table ‘movies’. Why is ‘year’ blue even though it’s referring to a column we are selecting? I’ve so far only seen blue words = clauses.
According to a Google search (see this article-about number 822), year is actually a keyword in some forms of SQL databases. Here is the full Google search results page, if you’re interested.
4 Likes
Lol you’re great. Thanks! So basically, in SQL if it’s a keyword it’s blue?
1 Like
In the Codecademy learning environment, yes. If you use other text editors/other SQL parsing/writing software, the keywords might be coloured differently.
1 Like
Got it. So same concept of highlighted keywords, but different software will use different colors to highlight.
Thank you!
1 Like
Bottom line, SQL will never show us RED. It only gives polite warnings.
3 Likes