missql-command
missql-command copied to clipboard
Should table/column name delimiters be permitted?
I mentioned on Reddit that I found delimiters are not recognised by the SQL parser. Whether they should be or not is probably a matter for debate, but I think I would veer towards yes, since popular tools like phpMyAdmin use them in their SQL output.
To start with, you could just silently accept them, but in later material you could explain that different engines use different delimiters - it depends on whether you wish to veer your material from standards-based SQL to provider-specific dialects. Backticks for MySQL, square brackets for SQL Server, probably something else again for PostgreSQL...