Use Mysql lower_case_table_names to 1

mysql tablename
Nirmal- thInk beYond picture Nirmal- thInk beYond · Nov 16, 2011 · Viewed 36.1k times · Source

I have installed mysql v5.5.17 in linux using yum, now i want default lowercase table names so i have added 

set-variable = lower_case_table_names=1

in /etc/my.cnf

but if i do that then i could not start mysqld service. Mysql logs says unknown variable lower_case_table_names. I have also tried with set global lower_case_table_names=1; in command line but is says its read only variable.

any suggestion?

Answer

Richardhe2007 picture Richardhe2007 · Jul 29, 2014

my OP system is ubuntu, Mysql version is 5.5.*

update file /etc/mysql/my.cnf, (must add under the section [mysqld])

[mysqld]

lower_case_table_names=1

then restart mysql

Related questions

How to select from MySQL where Table name is Variable

I have a case where getting the table name should be from a set variable like: SET @ID_1 = (SELECT ID FROM `slider` LIMIT 0,1); SET @Cat = (SELECT Category FROM `slider` LIMIT 0,1); select * from @Cat where ID = @ID_1 but doing that way …

Read More
mysql (5.1) > create table with name from a variable

I'm trying to create a table with a name based on the current year and month(2011-09), but MySQL doesn't seem to like this. SET @yyyy_mm=Year(NOW())+'-'+Month(NOW()); CREATE TABLE `survey`.`@yyyy_mm` LIKE `survey`.`interim`; …

Read More
How to use dynamic table name in SELECT query using JDBC

I have 5 or table table to query from \ my syntax i like this String sql2 = "SELECT * FROM ? WHERE Patient_ID = ?"; pst = conn.prepareStatement(sql2); System.out.println("SQL before values are set "+sql2); System.out.println("The values of table/…

Read More