Ever had an experience where you needed to rename a handful of table name into upper case. Below is a procedure to rename all tables into upper case in the current MySQL database/schema.

Just run the script and call it using

then it will rename the tables. Be reminded though that you need to specify the database to be used before connecting to MySQL or by using the use command.