查询mysql为空的表

SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'your_database_name'
AND table_rows = 0;

SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'test_db'
AND table_rows = 0;

DELIMITER //

CREATE PROCEDURE CleanupEmptyTables()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE tableName VARCHAR(255);
    DECLARE cur CURSOR FOR
        SELECT table_name
        FROM information_schema.tables
        WHERE table_schema = 'your_database_name'
        AND table_rows = 0;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO tableName;
        IF done THEN
            LEAVE read_loop;
        END IF;
        SET @dropSql = CONCAT('DROP TABLE ', tableName);
        PREPARE stmt FROM @dropSql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;

CALL CleanupEmptyTables();