Escaping Restricted Keywords
Escaping a restricted keyword that has been used as an identifier will allow the object associated with the identifier to be queried as usual.
One way to do this is to ensure the identifier involving a restricted keyword follows a period, because words following periods are always considered as identifiers in MySQL.database_
would run successfully, but a query referring to the table as begin
would return an error due to begin
being a restricted keyword.
Another method for escaping these keywords is wrapping them in backticks.begin
could also be escaped as follows: `begin`
.
Last modified: August 5, 2024