Identifiers
11 important questions on Identifiers
Of which characters may an unquoted identifier exist?
May an unquoted identifier begin with a digit?
What characters are invalid for database and table names within a quoted identifier?
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
May a quoted identifier consist solely of digits?
What type of identifiers are case sensitive and under what circumstances?
Are stored routine and trigger identifiers case sensitive?
Are column and index identifiers case-sensitive?
Are column aliases case-sensitive?
Are stored routines nested under the database identifier or the table identifier?
What 2 quoting characters are there for reserved words as database, table, index or column identifier?
ANSI_QUOTES = double quotes
Are reserved words case-sensitive in MySQL?
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