In Windows there are no case sensitive table names by default but in UNIX by default tables are case sensitive. You might have problem if you move your database from windows to UNIX platform and your code getting the error ‘no such table exists’ where your code works fine in window. This is because of table name are by default case sensitive in UNIX. Example: If you have table name which is uppercase letter named employee but when your code have the name of the table in lower case letter, it’s getting error or vice versa. mysql> CREATE TABLE EMPLOYEE ) ENGINE=InnoDB; mysql> Select * from employee; Error: No such table exist How to make case insensitive Table Name in UNIX: mysql> alter table EMPLOYEE rename employee; Add /etc/my.cnf mysql> show variables like 'lower%';
It’s Done. Now the table name is not case sensitive anymore. |