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'”
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.