Question · SQL and MySQL course · Module 1: Introduction to databases
Letter case in SQL
How does SQL treat the case of keywords (e.g. SELECT vs select)?
Answer options
- Keywords must be written only in lowercase
- It makes no difference - they work the same, but by convention we write them in UPPERCASE
- Each keyword must start with a capital letter and end lowercase
- The case changes the result of the query
Show the answer
Correct answer:
- It makes no difference - they work the same, but by convention we write them in UPPERCASE