Understanding 3 parameters in MySQL workbench Code Editor settings

Asked Nov 05 '20 at 21:30

Active Nov 05 '20 at 21:59

Viewed 90 times

What do the following three settings mean in MySQL Workbench?

These three parameters are mentioned briefly on the General Editor Settings, but I'm wondering what might be an example of their usage. For example:

SQL Identifiers are Case Sensitive: Enabled by default. Whether to treat identifiers separately if their names differ only in letter case.

Does this mean, for example that:

SELECT * from main_iteminstance

is different from:

SELECT * FROM main_iteminstance

The answer is no when I tried both, but isn't FROM a sql identifier, so what would this setting mean exactly?

edited Nov 05 '20 at 21:41

Shadow

asked Nov 05 '20 at 21:30

David542

@Shadow -- so in the above, 'identifiers' = table names? – David542 Nov 05 '20 at 21:47
Pls read the linked mysql manual page in the accespted answer of the identifier duplicate. – Shadow Nov 05 '20 at 22:00
@Shadow just to clarify, this one you mean? https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html – David542 Nov 05 '20 at 22:01

0 Answers0