MySQL 函数

MySQL 函数.md

DROP PROCEDURE IF EXISTS t_redis_rename_table;
DELIMITER //
CREATE PROCEDURE t_redis_rename_table() 
BEGIN
    IF NOT EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'apiserver' AND table_name='t_redis_v1') THEN
        ALTER TABLE `apiserver`.`t_redis` RENAME `apiserver`.`t_redis_v1`;
    END IF;
END //
DELIMITER ;
CALL t_redis_rename_table();
DROP PROCEDURE IF EXISTS t_redis_rename_table;