blocks|key|1200407|text|好的，实际上我偶然发现了答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1200408|phpMyAdmin确实提供了一个简短的历史。如果你点击'phpMyAdmin‘标志下面的'sql’图标，它将打开一个新窗口。在新窗口中，只需单击“历史记录”选项卡。|1200409|这将为您提供最后20个左右的SQL操作。|1200410|​|1200411|📷|atomic|offset|length|1200412|1200413|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/3f966590fd622096b2640783b841ec68.png|imageAlt^0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|10|8|@]|9|@$K|11|L|12|1|13]]|A|$]]|$1|M|3|G|5|6|7|14|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U|V|-4]]]]

Ok, so I actually stumbled across the answer.
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.
That will give you the last twenty or so SQL operations.
<a href="https://i.stack.imgur.com/9GFga.png" rel="noreferrer"><img src="https://i.stack.imgur.com/9GFga.png" alt="enter image description here" /></a>

blocks|key|1200792|text|要查看过去的查询，只需在phpMyAdmin中运行此查询即可。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1200793|SELECT+*+FROM+`general_log`|code-block|syntax|javascript|1200794|如果未启用，请在运行它之前运行以下两个查询。|1200795|SET+GLOBAL+log_output+=+'TABLE';
SET+GLOBAL+general_log+=+'ON';|1200796|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

To view the past queries simply run this query in phpMyAdmin.

<pre><code>SELECT * FROM `general_log`
</code></pre>

if it is not enabled, run the following two queries before running it.

<pre><code>SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'ON';
</code></pre>

blocks|key|985747|text|我不认为phpMyAdmin允许你这么做，但我希望听到我错了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|985748|另一方面，您可以在MySQL：The+General+Query+Log中启用查询日志记录|offset|length|985749|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.0/en/query-log.html^0|0|F|L|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

I don't think phpMyAdmin lets you do that, but I'd like to hear I'm wrong.

On the other hand you can enable query logging in MySQL: <a href="http://dev.mysql.com/doc/refman/5.0/en/query-log.html" rel="nofollow noreferrer">The General Query Log</a>

blocks|key|1200452|text|可以，您可以将查询记录到特殊的phpMyAdmin+DB表中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1200453|参见SQL_history。|offset|length|1200454|entityMap|0|LINK|mutability|MUTABLE|url|http://wiki.phpmyadmin.net/pma/SQL_history^0|0|2|B|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

Yes, you can log queries to a special phpMyAdmin DB table.

See <a href="http://wiki.phpmyadmin.net/pma/SQL_history" rel="nofollow noreferrer">SQL_history</a>.

blocks|key|986055|text|我正在使用phpMyAdmin服务器版本:+5.1.41。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|986056|它提供了通过phpmyadmin.pma_history表查看sql历史的可能性。|offset|length|style|CODE|986057|您可以在此表中搜索查询。|986058|pma_history表的结构如下：|986059|​|986060|📷|atomic|986061|986062|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/f0a28feb1405541ff0abae740f0e803c.png|imageAlt^0|0|6|M|0|0|0|B|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@$D|12|E|13|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|14|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|15|8|@$D|16|E|17|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|18|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|19|8|@]|9|@$D|1A|E|1B|1|1C]]|A|$]]|$1|Q|3|M|5|6|7|1D|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y|Z|-4]]]]

I am using phpMyAdmin Server version: 5.1.41.

It offers possibility for view sql history through <code>phpmyadmin.pma_history</code> table.

You can search your query in this table.

<code>pma_history</code> table has below structure:

<img src="https://i.stack.imgur.com/zOQ5g.png" alt="enter image description here">

blocks|key|1200608|text|您必须单击phpMyAdmin徽标正下方的query+window，一个新窗口将打开。只需单击SQL+History选项卡。您可以在那里查看SQL查询的历史记录。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1200609|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You have to click on query window just below the phpMyAdmin logo, a new window will open.
Just click on SQL History tab. There you can see history of SQL Queries.

blocks|key|1200277|text|我可能错了，但我相信我已经在phpmyadmin会话的会话文件中看到了以前的SQL查询列表|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1200278|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I may be wrong, but I believe I've seen a list of previous SQL queries in the session file for phpmyadmin sessions

blocks|key|1200877|text|您可以使用run+/PATH_+past+_+mysql+/bin/mysqld.exe运行以前的MYSQL|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1200878|它运行您最后一个mysql，您可以在phpmyadmin和系统的其他部分中看到它。|1200879|注意:停止您当前的mysql版本。|1200880|我的英语不好。|1200881|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

you can run your past mysql with run /PATH_PAST_MYSQL/bin/mysqld.exe

it run your last mysql and you can see it in phpmyadmin and other section of your system.

notice: stop your current mysql version.

S F My English.

blocks|key|986451|text|为什么不使用导出，然后单击‘自定义-显示所有可能的选项’单选按钮，然后选择您的数据库，然后转到输出并选择‘查看输出为文本’只需向下滚动并继续。瞧！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|986452|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

why dont you use export, then click 'Custom - display all possible options' radio button, then choose your database, then go to Output and choose 'View output as text' just scroll down and Go. Voila!

blocks|key|1200663|text|有一个叫做Adminer的工具，它能够完成打包在一个很小的php文件中的所有phpmyadmin工作。http://www.techinfobit.com/how-to-import-export-database-without-any-extra-installation/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1200664|entityMap|0|LINK|mutability|MUTABLE|url|http://www.techinfobit.com/how-to-import-export-database-without-any-extra-installation/^0|1F|2G|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

There is a tool called Adminer which is capable of doing all phpmyadmin job packed in single tiny php file. 
<a href="http://www.techinfobit.com/how-to-import-export-database-without-any-extra-installation/" rel="nofollow">http://www.techinfobit.com/how-to-import-export-database-without-any-extra-installation/</a>

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

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

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

Is there a way to view them in phpmyadmin?

Is there a way to view past mysql queries with phpmyadmin?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我正在尝试追踪一个在mysql表中删除行的bug。对于我来说，我无法在我的PHP代码中找到它，所以我想通过找到删除行的实际mysql查询来反向工作。我登录到phpmyadmin，但是找不到查看过去sql操作的历史记录的方法。有没有办法在phpmyadmin中查看它们？

问有没有办法用phpmyadmin查看过去的mysql查询？
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问有没有办法用phpmyadmin查看过去的mysql查询？EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问有没有办法用phpmyadmin查看过去的mysql查询？
EN