change table name to upper case

Question

I need to change table name from lowercase to uppercase but using this statement the table name can be changed but the names are in lowercase..

sql> rename table name to Name; 

is there any way to convert table name to uppercase?

Answer 1

1. Add this line in the mysql server variables array in my.cnf:

   lower_case_table_names=2 

2. Restart your mysql server.

3. Now you can create or alter tables in upper case, the server will accept your query.

Note that usually, on Linux systems, the main mysql configuration file can be found in /etc/my.cnf or /etc/mysql/my.cnf.

Answer 2

This should give u what you are looking for...

ALTER TABLE oldtable RENAME TO NewTable;