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?

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html — Vishwanath Dalvi, Jun 07 '12 at 08:42

score 27 · Accepted Answer · edited Nov 02 '18 at 21:40

27

Add this line in the mysql server variables array in my.cnf:
```
lower_case_table_names=2
```
Restart your mysql server.
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.

edited Nov 02 '18 at 21:40

1stthomas

731
2
15
22

answered Jun 07 '12 at 08:41

aleroot

71,077
30
176
213

where I should put this statement in the file – user2012 Jun 07 '12 at 08:52
Is this applicable for Views?? – Anil Kumar Reddy Mar 08 '18 at 11:47
I'm running mysql inside docker, and setting lower_case_table_names to 1 worked for me (I believe I'm using 5.7) – slim Jan 08 '19 at 16:55
1

some more information about mysql and identifiers can be found https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html – morecore May 16 '19 at 15:45

score 7 · Answer 2 · edited May 10 '23 at 20:39

7

Simple

sql> rename table name to tempName;
sql> rename table tempName to Name;

Without giving a tempName, MySQL does not recognize any change, ie when running sql> rename table name to Name; response is

Error Code: 1050. Table 'Name' already exists

edited May 10 '23 at 20:39

SimPHP

33
1
8

answered Jun 07 '12 at 08:48

Alfred

21,058
61
167
249

peixe · Answer 3 · 2012-06-07T09:23:02.147

5

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

ALTER TABLE oldtable RENAME TO NewTable;

edited Jun 07 '12 at 09:23

answered Jun 07 '12 at 08:43

peixe

1,272
3
14
31

score 5 · Answer 4 · edited Jun 20 '20 at 09:12

If you use EasyPHP (Maybe it also works for WAMP/XAMP/LAMP?) this worked for me:

Open the following file in the EasyPHP installation folder:

\binaries\conf_files\my.ini

Just under the line where it is written:

[mysqld]

Write:

lower_case_table_names=2

So you'll have:

[mysqld]

lower_case_table_names=2

EasyPHP will notice the change in this file and restart, but you can always manualy restart to make sure.

You can test the variable using the command:

SHOW VARIABLES LIKE 'lower_case_table_names';

Or in phpMyAdmin go to: Home > Variables, and search for "lower case table names".

how to change view name to upper case?? – Anil Kumar Reddy Mar 08 '18 at 11:57 — Anil Kumar Reddy, Mar 08 '18 at 11:57

score 0 · Answer 5 · answered Sep 20 '22 at 10:13

0

If you are using the XAMPP server then follow these steps:

a. Open XAMPP and right click on Config button :
b. Just under the line where it is written:

[mysqld]

Write

lower_case_table_names=2

After this change restart the mySQL (Just Stop/Start)

answered Sep 20 '22 at 10:13

Hardik Kalathiya

2,221
1
18
28

change table name to upper case

5 Answers5

Linked