E-Mail

Fragen:


SET global group_concat_max_len=150000;




SET session group_concat_max_len=150000;


// Report IST-Stand
UPDATE reports
SET current_status_final = (
    SELECT GROUP_CONCAT(answer order by sort_order SEPARATOR ' ')
		FROM reviews    
		WHERE main_category = 16
)
WHERE id = 16;

// Report Review

UPDATE reports
SET review_final = (
    SELECT GROUP_CONCAT(review order by sort_order SEPARATOR ' ')
		FROM reviews    
		WHERE main_category = 16
)
WHERE id = 16;