Home > Articles > Data > MySQL

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


  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