missql-command icon indicating copy to clipboard operation
missql-command copied to clipboard

Should table/column name delimiters be permitted?

Open halfer opened this issue 11 years ago • 0 comments

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...

halfer avatar Oct 31 '14 18:10 halfer