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
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With