Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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