quote_identifier
Syntax
sys.quote_identifier(str)
Description
quote_identifier
is a stored function available with the Sys Schema.
It quotes a string to produce a result that can be used as an identifier in an
SQL statement. The string is returned enclosed by backticks ("`
") and
with each instance of backtick ("`
") doubled. If the argument
is NULL
, the return value is the word "NULL
" without enclosing
backticks.
Examples
SELECT sys.quote_identifier("Identifier with spaces"); +------------------------------------------------+ | sys.quote_identifier("Identifier with spaces") | +------------------------------------------------+ | `Identifier with spaces` | +------------------------------------------------+ SELECT sys.quote_identifier("Identifier` containing `backticks"); +-----------------------------------------------------------+ | sys.quote_identifier("Identifier` containing `backticks") | +-----------------------------------------------------------+ | `Identifier`` containing ``backticks` | +-----------------------------------------------------------+
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.