1.å¨æå
¥çæ¶åå¤æï¼
$time = 0;
$sql = "insert into date (name,date) values('111',if('{$time}','{$time}',null))";
è¿æ ·ä¼å¨æå
¥ 0 æ¶ å为 null,æè
æå
¥ 0 çæ¶å æ¹ä¸º now()
2.å¨æ¥è¯¢æ°æ®å¤æï¼
SELECT id, name,if(date = '0000-00-00 00:00:00', NULL , date ) AS date FROM `date`
è¿æ ·å°±ä¼å°å¼ä¸º 0000-00-00 00:00:00 转æ¢ä¸º null
3 设置sql_model
mysql_query("set sql_mode='no_zero_date'");
mysql_query("insert into date (name,date) values('xxx'0)");
å¦æå¨temestamp åæå
¥ 0 ä¼äº§çè¦åï¼ä½æ¯æ°æ®è¿æ¯ä¼æå
¥æåï¼å¦ææå
¥ 0 失败çè¯sql_model 为ï¼set sql_mode='strict_all_tables,no_zero_date';
è¿æ ·æå
¥å°±ä¼æ¥å¦ä¸é误ï¼
ERROR 1292 (22007): Incorrect datetime value: '0' for column 'date' at row 1
温馨提示:答案为网友推荐,仅供参考