Are column and table name case sensitive in MySQL?

by

On Unix, table names are case sensitive. On Windows, they are not. Fun, isn’t it? Kinda like their respective file systems. Do you think it’s a coincidence?

In other words, if you are developing on Windows but planning on deploying to a Linux machine, better test your SQL against a Linux-based MySQL too, or be prepared for mysterious “table not found” errors at prod time. VMs are cheap these days.

Field (column) names are case-insensitive regardless.

EDIT: we’re talking about the operating system on the MySQL server machine, not client.

More Related Contents:

  1. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  2. How can I make SQL case sensitive string comparison on MySQL?
  3. Are table names in MySQL case sensitive?
  4. Troubleshooting “Illegal mix of collations” error in mysql
  5. UTF-8: General? Bin? Unicode?
  6. MySQL case sensitive query [duplicate]
  7. How to change the CHARACTER SET (and COLLATION) throughout a database?
  8. How to change collation of database, table, column?
  9. What effects does using a binary collation have?
  10. Like Case Sensitive in MySQL
  11. Illegal mix of collations error in MySql
  12. SQL unique varchar case sensitivity question
  13. What is the best MySQL collation for German language
  14. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  15. MySQL treats ÅÄÖ as AAO?
  16. How to force case sensitive table names?
  17. How to change the default charset of a MySQL table?
  18. How do you force mysql LIKE to be case sensitive? [duplicate]
  19. MySQL Illegal mix of collations
  20. MySQL’s lower_case_table_names won’t change
  21. How do you use MYSQL in ColdFusion? [closed]
  22. Using backticks around field names
  23. How do I do a bulk insert in mySQL using node.js
  24. Save Data in Arabic in MySQL database
  25. GROUP_CONCAT with limit
  26. SQL Query to show nearest date?
  27. How can I modify the size of column in a MySQL table?
  28. How to get database structure in MySQL via query
  29. Encryption at rest and/or AES_ENCRYPT
  30. GRANT with database name wildcard in MySQL?

Leave a Comment