How to force case sensitive table names?

by

Read the following chapter in the official MySQL documentation: Identifier Case Sensitivity.

Then add the following system variable to the server section, [mysqld], inside the my.ini configuration file and restart the MySQL service:

lower_case_table_names=2

More Related Contents:

  1. How can I make SQL case sensitive string comparison on MySQL?
  2. Are table names in MySQL case sensitive?
  3. MySQL case sensitive query [duplicate]
  4. mysql2 gem compiled for wrong mysql client library
  5. How can I access the MySQL command line with XAMPP for Windows?
  6. Are column and table name case sensitive in MySQL?
  7. What is the location of mysql client “.my.cnf” in XAMPP for Windows?
  8. mysql configuration stops at “starting server”
  9. Import SQL file into mysql
  10. Like Case Sensitive in MySQL
  11. SQL unique varchar case sensitivity question
  12. “193: %1 is not a valid Win32 application” bug with a new Rails Application
  13. MySQL my.ini location
  14. Where does MySQL store database files on Windows and what are the names of the files?
  15. How do you force mysql LIKE to be case sensitive? [duplicate]
  16. Xampp-mysql – “Table doesn’t exist in engine” #1932
  17. MySQL’s lower_case_table_names won’t change
  18. 1064 error in CREATE TABLE … TYPE=MYISAM
  19. MySQL DELETE FROM with subquery as condition
  20. How to use LOAD_FILE to load a file into a MySQL blob?
  21. Relational database design multiple user types
  22. Checking multiple columns for one value
  23. What is better in MYSQL count(*) or count(1)?
  24. #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
  25. How to enable INNODB in mysql
  26. MySQL Insert & Joins
  27. How to join two tables using a comma-separated-list in the join field
  28. How do I write an SP in phpMyAdmin (MySQL)?
  29. INSERT INTO Table from multiple tables
  30. Counting associated entries with Sequelize

Leave a Comment