MySQL has a multitude of functions and identifiers which are designated Reserved Words. Since these reserved words have special meaning or functions within the MySQL language, it is best to avoid using them as table, column or field names if at all possible. The best known are CREATE, SELECT, UPDATE and DROP. These reserved words are used as commands in MySQL for performing database operations. These commands are used to create, change or delete databases and datasets. Reserved words in MySQL are usually uppercase to distinguish them from the rest of the MySQL command in documentation, syntax examples, etc. but are actually case-insensitive. While you may be able to type MySQL reserved words in all lowercase without functionality being compromised, it is best practice to follow the de facto standard.
There is a different list of reserved words for each version of MySQL due to the introduction of new functions. The list of reserved words is backwards compatible. In other words, the terms that were reserved in MySQL 4.0 are still reserved in the current release of MySQL.
Correct using quotation marks:
Correct using the table name: