Description:
Variable -- lower_case_table_names is not effecting anything in query level
Below is the output which i am getting is just for your reference
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select * from mts.users;
+--------+-------------+----------------------------------+--------+-------------+-----------+-----------------+------------+------------+-----------------------+---------------------+
| userID | user_name | password | roleID | first_name | last_name | designation | doj | phone | email | lastupdated |
+--------+-------------+----------------------------------+--------+-------------+-----------+-----------------+------------+------------+-----------------------+---------------------+
| 1 | naganand | ea89630952aa5e3a68aa9788586dea60 | 1 | Naganand | | | 2010-04-09 | | | 2010-04-17 15:16:00 |
| 2 | biju | 1d683d2f77ebd646f11b4afe50d6f9ca | 1 | biju | ka | Java Programmer | 2010-03-01 | 9035448060 | biju@grameenkoota.org | 2010-07-28 13:11:42 |
| 4 | anil | 71b9b5bc1094ee6eaeae8253e787d654 | 0 | Girish | Jogi | | 2010-04-09 | | | 2010-04-19 17:32:22 |
| 9 | admin | 21232f297a57a5a743894a0e4a801fc3 | 1 | admin | | | 2010-07-13 | | | 2010-07-13 19:21:39 |
| 10 | anil | 7bb083eda01aa4ba8e0235d56a2d5102 | 5 | anil | | | 2010-07-13 | | | 2010-07-13 19:26:27 |
+--------+-------------+----------------------------------+--------+-------------+-----------+-----------------+------------+------------+-----------------------+---------------------+
9 rows in set (0.00 sec)
mysql> select * from mts.Users;
ERROR 1146 (42S02): Table 'mts.Users' doesn't exist
mysql>
I have added lower_case_table_names=1 variable in my.cnf file. I'm not seeing any change in query level
Herewith I'm attaching my.cnf file is for your verification.
Kindly do the needfull. Thanks
How to repeat:
same as above
