MySQL Forums
Forum List  »  General

Disable strict mode MySQL
Posted by: Ramon Soto
Date: February 19, 2020 10:09AM

Hi!

I can't find the MySql server CNF file on my Mac using the my.cnf keywords. I'm trying to disable strict mode since there are command lines I am not allowed to use. For instance:

insert into branch(branch_name) values ('Lloyds') gives the following error:

"Error Code: 1364. Field 'branch_name' doesn't have a default value"

Does anyone know where how to disable this? I have already set the SQL mode to 'no_engine_substitution" on the preferences tab on MySQL workbench, restarted the session, but it didnt get fixed. Does anyone know how fit it? I'm using Mac OS x Mojave 10.14.3.

Thanks!

Options: ReplyQuote


Subject
Written By
Posted
Disable strict mode MySQL
February 19, 2020 10:09AM
February 19, 2020 12:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.