admin管理员组

文章数量:1345452

I am setting the sql_mode for the MySQL session into non-strict SQL Mode as below on the PDO object.

I have excluded the modes STRICT_ALL_TABLES or STRICT_TRANS_TABLES above. I have a table with createdDate(DATETIME) and updatedDate(DATETIME) columns which are not null and do not have default values.

When I try to make an insert into that table without values for those 2 columns, I still receive an error saying values are not specified for those columns in the insert statement. Ideally the insert queries should work and those 2 columns should have 0000-00-00 00:00:00 as the value for those rows.

Why does this error happen and how can I fix it? I do not want to set the sql_mode for the whole database server into non-strict SQL Mode as it will affect other databases.

本文标签： phpSetting the MySQL sqlmode for the session is not workingStack Overflow

版权声明：本文标题：php - Setting the MySQL sql_mode for the session is not working - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1743770722a2536072.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。