The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

SET SESSION sql_mode

SET SESSION sql_mode

0
Votes
1
Answer

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 Answer

365 Team
0
Votes

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