Skip to content

Instantly share code, notes, and snippets.

@stevej
Created March 17, 2009 18:12
Show Gist options
  • Save stevej/80691 to your computer and use it in GitHub Desktop.
Save stevej/80691 to your computer and use it in GitHub Desktop.
# Used in conjuction with mysqlbinlog, this awk script will print out
# the SQL operation and the table being modified.
# Collate with sort | uniq -c | sort -rn
/^UPDATE/{ print $1, $2 }
/^INSERT|^DELETE/{ print $1, $3}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment