This can be done very easily. Run the following query
SET @@global.sql_mode= '';
Open your “my.ini” file within the MySQL installation directory, and look for the text “sql-mode“.
# Set the SQL mode to strict sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
# Set the SQL mode to strict sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Subscribe to our mailing list
Subscribe to our mailing list and receive a free udpates
Thank you for subscribing.
Something went wrong.