MySQL get recent Updates and Inserts-CodePudding

Home > Back-end > MySQL get recent Updates and Inserts

MySQL get recent Updates and Inserts

Time：12-14

I've MySQL 5.7. There are some recent update statements ran in MySQL and I have to see what update statement did they run. I tried the mysqlbinlog <bin-log> but it give lots of output which I'm not able to trace the recent ones.

CodePudding user response：

I think you missed a -v in your command:

mysqlbinlog -v <bin-log>

Page link：https//www.codepudding.com/Backend/641948.html

Prev:Proper way to implement near-match searching MySQL

Next:MySQL dump a table or saving table contents as a python dictionary

Tags：

mysql

Links：
CodePudding