mysql - MySQL Keywords as column name

Question

Scenario I have a MYSQL table with a column called text. I've only recently realized that TEXT is in fact a MYSQL keyword, but I haven't had any problems using that column name.

Background I've already noticed from the MYSQL documentation that there is a difference between reserved words and keywords: reserved words are more restrictive in that they need to be quoted with back ticks if you want to use them as identifiers. This question is about keywords, not reserved words.

Question Are there any problems that could come up with having a keyword such as text or type as a column name?

• If yes, in which scenario?
• If not, why do we even care that they are keywords? Is there any difference at all to a custom name?

标签： mysqlkeywordtable-structure