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