MySQL: Select the last executed queries

Question

How to select the last executed queries in MySQL?

Would you mind giving us a few more details, please? Thanks. — Pete Wilson, Apr 13 '11 at 20:20
I know that in oracle we have a "select" that returns the queries history. Is there something similar in MySQL? — Victor, Apr 13 '11 at 20:22
possible duplicate of [How to show the last queries executed on MySQL?](http://stackoverflow.com/questions/650238/how-to-show-the-last-queries-executed-on-mysql) — kapa, Apr 13 '11 at 20:25

score 0 · Accepted Answer · edited May 23 '17 at 10:26

0

You can enable the General Query Log.

Edit: Duplicate question. Answer here.

edited May 23 '17 at 10:26

Community

answered Apr 13 '11 at 20:21

Bradford

score 0 · Answer 2 · answered Apr 13 '11 at 20:21

If the general query log is enabled, then you can use tail to see the most recent queries executed on your server.

If the general query log is disabled, there is no way to do this.

If the binary log is enabled you can see the most recent insert/update/delete queries in there, but not selects.

2 Answers2