Home > Articles > Data > MySQL

  • Print
  • + Share This
This chapter is from the book

Q&A

  1. If strings in WHERE clauses are case insensitive, what is and isn't case insensitive?

  1. SQL commands and names of fields are case insensitive. The following statements return the same results:

  2. 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
  • + Share This
  • 🔖 Save To Your Account