?
How are identifiers quoted in MySQL?
Answer & Solution
Correct Answer:
Option
C
In MySQL, identifiers such as table names, column names, database names, etc., are quoted using backticks.
Using backticks is optional for identifiers unless the identifier matches a reserved word or contains special characters.
Option A, single quotes, is incorrect because single quotes are used to denote string literals, not identifiers, in MySQL.
Option B, double quotes, is incorrect because double quotes are also used to denote string literals, not identifiers, in MySQL.
Option D, can't be quoted, is incorrect because identifiers can indeed be quoted in MySQL, especially when they contain special characters or match reserved words.
Using backticks is optional for identifiers unless the identifier matches a reserved word or contains special characters.
Option A, single quotes, is incorrect because single quotes are used to denote string literals, not identifiers, in MySQL.
Option B, double quotes, is incorrect because double quotes are also used to denote string literals, not identifiers, in MySQL.
Option D, can't be quoted, is incorrect because identifiers can indeed be quoted in MySQL, especially when they contain special characters or match reserved words.
Join the Discussion
Login to post a comment or share your explanation.
Login