Ask if mysql's showprocesslist command can display the complete SQL statement

Ask if the mysql showprocesslist command can display the complete SQL statement, as shown in the following figure:

You can use show processlist to display only the first short segment of an SQL statement.

How to view the complete SQL statement

Reply to discussion (solution)

The show full processlist method is found.

13.5.4.16. show processlist syntax
SHOW [FULL] PROCESSLIST
Show processlist shows which threads are running. You can also use the mysqladmin processlist statement to obtain this information. If you have SUPER permission, you can see all the threads. Otherwise, you can only view your own thread (that is, the thread associated with the MySQL account you are using ). See section 13.5.5.3 "KILL syntax ". If you do not use the FULL keyword, only the first 100 characters of each query are displayed.