Mysql change all table names to lower case

Question

I have got 10 tables in mysql all starting with uppercase, I was wondering if can change all of them to lowercase with one query rather than 20?

https://stackoverflow.com/questions/2659684/why-my-tables-names-are-converted-into-lowercase-in-phpmyadmin — Usha Chowdary, Jun 07 '17 at 09:31

Ghostman · Accepted Answer · 2017-06-07T11:12:40.990

5

select concat('rename table ', table_name, ' to ' , lower(table_name) , ';')from information_schema.tables where table_schema = 'your_schema_name';

edited Jun 07 '17 at 11:12

answered Jun 07 '17 at 09:28

Ghostman

What is table_schema? – sasasasa Jun 07 '17 at 09:29
table_schema is the database name. To show also the databases without any tables: SELECT s. schema_name, t. table_name FROM INFORMATION_SCHEMA --- check this link https://dev.mysql.com/doc/refman/5.7/en/tables-table.html – Ghostman Jun 07 '17 at 09:30
this query redirected me to information_schema table but didn't change the table names – sasasasa Jun 07 '17 at 09:32
Go through Amy Anuszewski answer link – Ghostman Jun 07 '17 at 09:33

1 Answers1