Examveda
Examveda

How are identifiers quoted in MySQL?

A. single quotes

B. double quotes

C. backticks

D. can't be quoted

Answer: Option C

Solution(By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous