Kelechi Okezie
Last answered:

11 May 2020

 Posted on:

09 May 2020
0

SET SESSION sql_mode

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'"

1 answers ( 0 marked as helpful)
Martin Ganchev
Instructor
Posted on:

11 May 2020
0
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

Submit an answer