Identifiers

11 important questions on Identifiers

Of which characters may an unquoted identifier exist?

All alphanumeric + underscore + dollar sign

May an unquoted identifier begin with a digit?

Yes

What characters are invalid for database and table names within a quoted identifier?

'.', '/', '\' and byte x'0' and x'255'
  • Higher grades + faster learning
  • Never study anything twice
  • 100% sure, 100% understanding
Discover Study Smart

May a quoted identifier consist solely of digits?

Yes

What type of identifiers are case sensitive and under what circumstances?

Database and table names if the operating systems filesystem is case sensitive and lower_case_table_names is not 1 or 2

Are stored routine and trigger identifiers case sensitive?

No

Are column and index identifiers case-sensitive?

No

Are column aliases case-sensitive?

No

Are stored routines nested under the database identifier or the table identifier?

Database identifier

What 2 quoting characters are there for reserved words as database, table, index or column identifier?

Normal = backtick
ANSI_QUOTES = double quotes

Are reserved words case-sensitive in MySQL?

No

The question on the page originate from the summary of the following study material:

  • A unique study and practice tool
  • Never study anything twice again
  • Get the grades you hope for
  • 100% sure, 100% understanding
Remember faster, study better. Scientifically proven.
Trustpilot Logo