AWK : Parsing mysqld query log

Print only insert queires from mysqld query log. [Normally, a query is spread across multiple lines. ]

awk 'BEGIN{RS="Query"; ORS="\r\n$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$\r\n"} /INSERT/{print $0}' mysqldquery.log

awk 'BEGIN{RS="Query"; ORS="\r\n$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$\r\n"}tolower($0) ~ /insert/ {print $0}' mysqldquery.log //case insensitive search

Technorati Tags: commands, awk,