print_account_simple

Parameters

Name	Type
table_name	varchar(50)
level	int

SQL Definition

CREATE PROCEDURE `print_account_simple`(IN table_name varchar(50), IN level int)
BEGIN
    SET @stmt=CONCAT('SELECT ind,
                                code_of_account,
                                account_description,
                                total_cost,
                                level,
                                review_status
                                FROM ',table_name,' WHERE level <= ?');
        PREPARE stmt FROM @stmt;
        SET @level=level;
        EXECUTE stmt USING @level;
        DEALLOCATE PREPARE stmt;
END;;