Skip to content
Advertisement

Tag: grammar

Can a backticked identifier have a backtick in it?

Is it possible to escape a SQL identifier in either MySQL or BigQuery or any other RDBMS that allows quoting of identifiers with the ` character? For example: Works, but then How would I add a literal backtick to it, or is that just not allowed? Answer Yes. Use a doubled backtick, eg: This is similar syntax for including quotes

Advertisement