lowercase de todas as tabelas, MySQL

Language: Layout:

DROP TABLE IF EXISTS vidaloka, vidaboa, tabela_tmp;
DROP PROCEDURE IF EXISTS atualizar;

CREATE TABLE tabela_tmp (num INT, comando VARCHAR(1024));
CREATE TABLE vidaloka (id INT, nome VARCHAR(22));
CREATE TABLE vidaboa (id INT, nome VARCHAR(22));

INSERT INTO vidaloka (id, nome) values (1, 'LoKa 01'), (2, 'loka 02');
INSERT INTO vidaboa (id, nome) values (1, 'boa 01'), (2, 'Boa 02');

CREATE PROCEDURE atualizar()
BEGIN
    SET @row_number := 0;
    
    INSERT INTO tabela_tmp
    SELECT (@row_number:=@row_number + 1) AS num, CONCAT('update ', TABLE_NAME, ' SET ', CONCAT(GROUP_CONCAT(CONCAT(COLUMN_NAME, '=lower(', COLUMN_NAME, ')')), ';'))
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME LIKE 'vida%' -- limitei pra facilitar a visualização
    GROUP BY TABLE_NAME;

SET @id_tabela:=1, @total:=(SELECT COUNT(*) FROM tabela_tmp);

WHILE @id_tabela <= @total DO
        SET @comando = (SELECT comando FROM tabela_tmp where num = @id_tabela);

PREPARE myquery FROM @comando;
        EXECUTE myquery;

SET @id_tabela = @id_tabela + 1;    
    END WHILE;
END;

SELECT 'vidaloka' tabela, id, nome FROM vidaloka 
UNION 
SELECT 'vidaboa' tabela, id, nome FROM vidaboa;

call atualizar();

SELECT 'vidaloka' tabela, id, nome FROM vidaloka 
UNION 
SELECT 'vidaboa' tabela, id, nome FROM vidaboa;


absolute service time: 4,14 sec