<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7232.39">
<TITLE>Running ON INSERT UPDATE (MySQL)</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hii,</FONT>
<BR><FONT SIZE=2 FACE="Arial">I'm trying to update a table when I do an insert, do I have the syntax correct here?</FONT>
</P>
<BR>
<P><FONT FACE="Times New Roman">destination db_mysql { pipe("/var/log/mysql.pipe"<BR>
template("INSERT INTO logs (host, facility, priority, level, datetime, msg)<BR>
VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC','$MSG' ) ON INSERT UPDATE NumRows SET NumRowsLogs=NumRowsLogs+1;\n")<BR>
template-escape(yes)); };<BR>
</FONT>
<BR><FONT SIZE=2 FACE="Arial">TIA!</FONT>
<BR><FONT SIZE=2 FACE="Arial">-Clayton</FONT>
</P>
</BODY>
</HTML>