Pivot a table using MySQL 5

You must execute the code again to save those values in the database.

-- INIT database
CREATE TABLE doTable_critical (
   val_critical INT,
   qs VARCHAR(2),
   code_critical VARCHAR(255),
   code_line VARCHAR(100)
);

CREATE TABLE doTable_report (
   code_line VARCHAR(100)
);

INSERT INTO doTable_critical(val_critical, qs, code_critical, code_line) VALUES (1, 'YS', '4.01 - Passers', 'GX10-13686');
INSERT INTO doTable_critical(val_critical, qs, code_critical, code_line) VALUES (1, 'YS', '3.03 - Chains', 'GX10-13686' );

INSERT INTO doTable_report(code_line) VALUES ('GX10-13686');

SET SESSION group_concat_max_len = 500000;
    
    SET @SQL = NULL;
    
    SELECT
    	GROUP_CONCAT( DISTINCT CONCAT( 'SUM(CASE WHEN `code_critical` = ''', `code_critical`, ''' 
        AND `val_critical` = 1 AND `QS` = "YS"  THEN 1 ELSE 0 END) AS ''', `code_critical`, ''' ' ) ) INTO @SQL 
    FROM
    	`doTable_critical`;
    
    SET @SQL = CONCAT( 'SELECT DISTINCT _t.`code_line` , _q.`code_line`, ', @SQL, ' FROM `doTable_report` _t	
                        JOIN `doTable_critical` _q ON _t.`code_line` = _q.`code_line` 
                        WHERE _q.`val_critical` = "1" AND _q.`QS` = "YS"  
                        GROUP BY _t.`code_line`, _q.`code_line`, _q.`code_critical` ORDER BY _q.`code_line` ASC' );
    
    PREPARE stmt FROM @SQL;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;

code_line	code_line_1	3.03 - Chains	4.01 - Passers
GX10-13686	GX10-13686	0	1
GX10-13686	GX10-13686	1	0