mysql循环生成测试数据库

DELIMITER //

DROP PROCEDURE IF EXISTS generate_test_database//
CREATE PROCEDURE generate_test_database()
BEGIN
    DECLARE i INT DEFAULT 1;
    DECLARE table_name VARCHAR(50);
    
    -- 创建数据库
    CREATE DATABASE IF NOT EXISTS test_database;
    
    -- 使用数据库
    USE test_database;
    
    -- 循环创建表
    WHILE i <= 10 DO
        SET table_name = CONCAT('table_', i);
        
        -- 创建表
        CREATE TABLE IF NOT EXISTS table_name (
            id INT PRIMARY KEY AUTO_INCREMENT,
            name VARCHAR(50)
        );
        
        SET i = i + 1;
    END WHILE;
    
    SELECT 'Test database generated successfully!' AS result;
END//

CALL generate_test_database()//