有没有办法用phpmyadmin查看过去的mysql查询? [英] Is there a way to view past mysql queries with phpmyadmin?

问题描述

我正试图找出一个错误，该错误会删除mysql表中的行.

I'm trying to track down a bug that's deleting rows in a mysql table.

在我的生命中，我无法在我的PHP代码中对其进行跟踪，因此我想通过查找删除行的实际mysql查询来进行回溯.

For the life of me I can't track it down in my PHP code, so I'd like to work backwards by finding the actual mysql query that's removing the rows.

我登录到phpmyadmin，但是找不到查看过去sql操作历史记录的方法.

I logged in to phpmyadmin, but can't find a way to view the history of past sql operations.

有没有办法在phpmyadmin中查看它们?

Is there a way to view them in phpmyadmin?

推荐答案

好，所以我实际上偶然发现了答案.

Ok, so I actually stumbled across the answer.

phpMyAdmin确实提供了简短的历史记录.如果单击"phpMyAdmin"徽标下面的"sql"图标，它将打开一个新窗口.在新窗口中，只需单击历史记录"标签.

phpMyAdmin does offer a brief history. If you click on the 'sql' icon just underneath the 'phpMyAdmin' logo, it'll open a new window. In the new window, just click on the 'history' tab.

这将为您提供最后二十个左右的SQL操作.

That will give you the last twenty or so SQL operations.

这篇关于有没有办法用phpmyadmin查看过去的mysql查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！