MYSQL modifies the table name to a large-write stored procedure, mysql Stored Procedure

MYSQL modifies the table name to a large-write stored procedure, mysql Stored Procedure

This article will share with you the stored procedure of modifying the table name to uppercase in MYSQL. The specific content is as follows:

1. conditions:
1.1 Mysql settings are case sensitive
2. Execute the following stored procedures:

# Call uppercase ('database name') drop procedure if exists uppercase; create procedure uppercase (IN dbname VARCHAR (200) begin declare done int default 0; DECLARE oldname VARCHAR (200 ); DECLARE cur cursor for select table_name FROM information_schema.TABLES WHERE table_schema = dbname; declare continue handler for not found set done = 1; OPEN cur; repeat fetch cur INTO oldname; SET @ newname = UPPER (oldname); SET @ isNotSame = @ newname <> BINARY oldname; if not done & @ isNotSame then set @ SQL = CONCAT ('rename table '', oldname, ''to '', LOWER (@ newname), '_ tmp''); PREPARE tmpstmt FROM @ SQL; EXECUTE tmpstmt; SET @ SQL = CONCAT ('rename table'', LOWER (@ newname), '_ tmp' to '', @ newname, '''); PREPARE tmpstmt FROM @ SQL; EXECUTE tmpstmt; deallocate prepare tmpstmt; end if; UNTIL done end repeat; CLOSE cur; END

3. Execute the following statement:
Call uppercase ('database name ');

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.