cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

MySql Table names are case sensitive

MySql Table names are case sensitive , ORM frameworks are causing issues due to this when used with typed class names 

For example :

 

SELECT * FROM Customers -  Throws an error

#1146 - Table '<db>.Customers' doesn't exist
 

SELECT * FROM customers -  Returns the required rows

 

Please resolve this 

 

 

1 REPLY 1
Super User III Super User III
Super User III

Re: MySql Table names are case sensitive

I believe this is actually from the underlying operating system.  Linux is case-sensitive, Windows is not.

https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html