Are table names in MySQL case sensitive?

by

In general:

Database and table names are not case sensitive in Windows, and case sensitive in most varieties of Unix.

In MySQL, databases correspond to directories within the data
directory. Each table within a database corresponds to at least one
file within the database directory. Consequently, the case sensitivity of the
underlying operating system plays a part in the case sensitivity of
database and table names.

One can configure how tables names are stored on the disk using the system variable lower_case_table_names (in the my.cnf configuration file under [mysqld]).

Read the section: 10.2.2 Identifier Case Sensitivity for more information.

More Related Contents:

  1. How can I make SQL case sensitive string comparison on MySQL?
  2. MySQL case sensitive query [duplicate]
  3. Can’t connect to MySQL server on ‘localhost’ (10061)
  4. Are column and table name case sensitive in MySQL?
  5. Like Case Sensitive in MySQL
  6. SQL unique varchar case sensitivity question
  7. MySQL database with unique fields ignored ending spaces
  8. How to force case sensitive table names?
  9. SELECT INTO and “Undeclared variable” error
  10. MySQL 1062 – Duplicate entry ‘0’ for key ‘PRIMARY’
  11. How do you force mysql LIKE to be case sensitive? [duplicate]
  12. MySQL’s lower_case_table_names won’t change
  13. Should I use the datetime or timestamp data type in MySQL?
  14. MySQL ‘Order By’ – sorting alphanumeric correctly
  15. UPDATE multiple rows with different values in one query in MySQL
  16. MySQL date format DD/MM/YYYY select query?
  17. MySQL Foreign Key Error 1005 errno 150 primary key as foreign key
  18. Pass array to MySQL stored routine
  19. How to select from MySQL where Table name is Variable
  20. How to store a datetime in MySQL with timezone info
  21. Error Code: 1406. Data too long for column – MySQL
  22. How to export a mysql database using Command Prompt?
  23. How to pass parameters to mysql query callback in nodejs
  24. MySQL Incorrect datetime value: ‘0000-00-00 00:00:00’
  25. Checking a table for time overlap?
  26. Does mysql have the equivalent of Oracle’s “analytic functions”?
  27. MySQL UPDATE and SELECT in one pass
  28. where does MySQL store database files?
  29. MySQL: How to retrieve a random row or multiple random rows?
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment