Export database model from MySQLWorkbench to MariaDB PhpMyAdmin

I designed a database model on MySQLWorkbench. Then, I export the model to generate a SQL script. Finally, when I import it in MariaDB PhpMyAdmin it raises errors like :

#1067 – Invalid default value for ‘created’

MariaDB version : 10.5.4

Do you have any idea?

Add Comment
1 Answer(s)

Here is my solution:

create DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP

MySQL refused the date to be like this: 0000-00-00 00:00:00

Answered on August 30, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.