#1336 - Dynamic SQL is not allowed in stored function or trigger

gistfile1.sql

DELIMITER |

DROP TRIGGER IF EXISTS `vote_update` |
CREATE TRIGGER `vote_update`
AFTER INSERT ON `votes`
FOR EACH ROW

BEGIN

SET @row_day = CONCAT(DAYNAME(NOW()), '_votes');
    

	SET @sql_weekly := 'INSERT INTO `weekly_stats` (`server_id`, `year`, `number`,' + @row_day +
		'VALUES(NEW.server_id,' + YEAR(NOW()) + ',' + WEEK(NOW()) + ', 1)
		 ON DUPLICATE KEY UPDATE' + @row_day + '=' + @row_day + '+1';

	PREPARE weekly_stats FROM @sql_weekly;
	EXECUTE weekly_stats;

END;

|