Ucu Suryadi

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

without comments

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 = '';

 

Author

Written by Ucu Suryadi

November 17th, 2020 at 9:22 pm

Posted in MySQL

Leave a Reply