Seeroo It Solutions Blog Script to change case of mysql tables

Here is an SQL script that renames all tables in a mysql schema schema to its lower case form. select concat('rename table ', table_name, ' to temp' , ';','rename table temp to ', lower(table_name), ';' ) from information_schema.tables where table_schema = 'your-schema'; The above script generates SQL statements (which you can copy-paste) that will help you [...]The post Script to change case of mysql tables appeared first on Seeroo.