Cacher is the code snippet organizer for pro developers

INSERT INTO file_score_count(risk_score, file_count)
SELECT risk_score,total_file FROM (
    SELECT risk_score, COUNT(id) AS total_file
    FROM file_info
    WHERE risk_score IS NOT NULL
    GROUP BY risk_score ) AS risk_score_sum
ON DUPLICATE KEY UPDATE file_count=total_file