SET SESSION sql_mode

Question

In the user-defined vs system variable lecture of MySQL. I ran the code provided in the lecture "

SET SESSION sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

", but I encountered "Error Code: 1231. Variable 'sql_mode' can't be set to the value of 'STRICT_TRANS_TABLE'"

Answer 1

Hi Mark! Thanks for reaching out. Thank you very much for letting us know. Which version of Workbench are you using? Please use the following code instead.

SET SESSION sql_mode='NO_ZERO_DATE,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

Hope this helps.
Best,
Martin

SET SESSION sql_mode

Submit an answer