If strings in WHERE clauses are case insensitive, what is and isn't case insensitive?
SQL commands and names of fields are case insensitive. The following statements return the same results:
SELECT * FROM master_name WHERE NAME_ID = 1; select * from master_name where name_id = 1;
Table names and database names are case insensitive on Windows but are case sensitive on Linux/UNIX. On Linux/UNIX, the following query fails because the table name is master_name and not MASTER_NAME:
mysql> select * from MASTER_NAME; ERROR 1146: Table 'contactDB.MASTER_NAME' doesn't exist