Hii,
I'm trying to update a table when I do an insert, do I have the syntax correct here?

destination db_mysql { pipe("/var/log/mysql.pipe"
template("INSERT INTO logs (host, facility, priority, level, datetime, msg)
VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC','$MSG' ) ON INSERT UPDATE NumRows SET NumRowsLogs=NumRowsLogs+1;\n")
template-escape(yes)); };

TIA!
-Clayton