Are table names in MySQL case sensitive

Question

Are table names in MySQL case sensitive   On my Windows development machine the code I have is able to query my tables which appear to be all lowercase  When I deploy to the test server in our datacenter the table names appear to start with an uppercase letter   The servers we use are all on Ubuntu

User · Answer

It depends upon lower case table names system variable   show variables where Variable name  lower case table names    There are three possible values for this    0 - lettercase specified in the CREATE TABLE or CREATE DATABASE statement  Name comparisons are case sensitive   1 - Table names are stored in lowercase on disk and name comparisons are not case sensitive   2 - lettercase specified in the CREATE TABLE or CREATE DATABASE statement  but MySQL converts them to lowercase on lookup  Name comparisons are not case sensitive    Documentation

User · Answer

Table names in MySQL are file system entries  so they are case insensitive if the underlying file system is

User · Answer

Database and table names are not case sensitive in Windows  and case sensitive in most varieties of Unix or Linux  To resolve the issue  set the lower case table names to 1  lower case table names 1  This will make all your tables lowercase  no matter how you write them

User · Answer

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

User · Answer

Locate the file at  etc mysql my cnf  Edit the file by adding the following lines    mysqld    lower case table names 1   sudo  etc init d mysql restart  Run mysqladmin -u root -p variables   grep table to check that lower case table names is 1 now   You might need to recreate these tables to make it work

[mysql] Are table names in MySQL case sensitive?

Examples related to mysql

Examples related to case-sensitive

Examples related to mysql5