什么是MYSQL中DBCC INPUTBUFFER(@@ SPID)的等效语句(为当前连接或指定连接提供sql语句)? [英] What is equivalent statement of DBCC INPUTBUFFER(@@SPID)(which give sql statement for current connection otr specified connection) in MYSQL?

问题描述

DBCC INPUTBUFFER(@@SPID)的 MySQL等价语句是什么，它列出了当前连接或指定连接的sql语句?

What is the MySQL equivalent statement of DBCC INPUTBUFFER(@@SPID), which lists the sql statement for current connection or specified connection?

推荐答案

使用

Use SHOW PROFILES to see a list of the most recent statements sent to MySQL:

SHOW PROFILES;

如果您希望/需要查看当前正在运行的查询，请使用显示过程列表:

If you want/need to see currently running queries, use SHOW PROCESSLIST:

SHOW FULL PROCESSLIST;

FULL关键字意味着该列表将包括来自所有客户端的查询，而不仅仅是您在其上运行命令的客户端.

The FULL keyword means the list will include queries from all clients, not just the one you are running the command on.

这篇关于什么是MYSQL中DBCC INPUTBUFFER(@@ SPID)的等效语句(为当前连接或指定连接提供sql语句)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！