How to check the SQL_MODE in mysql for a single process?

Question

How can I check what SQL_MODE is a process is using?

so I see all processed that are currently running using SHOW PROCESSLIST

What I need to do is to know the SQL_MODE that a process is using?

I want to make sure the client that I am using did not change the SQL mode.

Thanks

Answer 1

Refer to this page.

To determine the current global or session sql_mode value, use the following statements:

SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;

You are primarily interested in the @@SESSION.sql_mode variable.