SELECT
        uat_reopened_stats.release_name
        (uat_reopened_stats.rate_bugs + qa_reopened_stats.rate_bugs + closed_reopened_stats.rate_bugs + done_reopened_stats.rate_bugs)

        INTO @releasename, @bugstotalreopenrate

    FROM
        qa_reopened_stats
        JOIN uat_reopened_stats ON qa_reopened_stats.release_name = uat_reopened_stats.release_name
        JOIN closed_reopened_stats ON closed_reopened_stats.release_name = uat_reopened_stats.release_name
        JOIN done_reopened_stats ON done_reopened_stats.release_name = uat_reopened_stats.release_name;


INSERT INTO release_stats (release_name, bugs_total_reopen_rate)
VALUES (@releasename, @bugstotalreopenrate)
ON DUPLICATE KEY UPDATE
    release_name=@releasename,
    bugs_total_reopen_rate=@bugstotalreopenrate;

END

MySQL [jira_statistics]> describe uat_reopened_stats;
+---------------------------+-------------+------+-----+---------+-------+
| Field                     | Type        | Null | Key | Default | Extra |
+---------------------------+-------------+------+-----+---------+-------+
| release_name              | varchar(45) | NO   | PRI | NULL    |       |
| rate_bugs                 | float       | YES  |     | NULL    |       |
+---------------------------+-------------+------+-----+---------+-------+