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

Related: https://stackoverflow.com/a/46277941/6064933 – jdhao Oct 01 '22 at 09:06 — jdhao, Oct 01 '22 at 09:06

score 7 · Answer 1 · answered Mar 12 '14 at 16:24

7

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.

answered Mar 12 '14 at 16:24

David H. Bennett

No, this only works for the current session you are on but does not give you the session of **another** client. – Pacerier Apr 22 '16 at 04:03

1 Answers1