17 Mar
2006
17 Mar
'06
3:26 p.m.
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