Strict mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE. A value can be invalid for several reasons. For example, it might have the wrong data type for the column, or it might be out of range. A value is missing when a new row to be inserted does not contain a value for a non-NULL column that has no explicit DEFAULT clause in its definition. (For a NULL column, NULL is inserted if the value is missing.) Strict mode also affects DDL statements such as CREATE TABLE.
Disable MySQL Strict Mode MAMP PRO
1. In MAMP Pro, go to File -> Edit Template -> MySQL (my.cnf) -> (your version)
2. Find
Code: Select all
[mysqld]
Code: Select all
sql_mode=""
Disable MySQL Strict Mode MAMP (Free)
1. Quit MAMP.
2. Run following command in the Terminal:
Code: Select all
touch /Applications/MAMP/conf/my.cnf && open -t /Applications/MAMP/conf/my.cnf
Code: Select all
[mysqld]
sql_mode=""