Loading
incorrect date value mysql

Incorrect date value: ‘0000-00-00’ for column MySQL

Saat mendapatkan error berikut:

ERROR 1067 (42000): Invalid default value for 'column_name'

dan

ERROR 1292 - Incorrect date value: '0000-00-00'

Simple-nya, berikan perintah berikut:

SET sql_mode = '';

atau

SET GLOBAL sql_mode = '';

 

Leave a Reply

Your email address will not be published. Required fields are marked *