The field clock_out of attendance should be set a default value

[littleLi-star7]

when i create the attendance table the error occured , it hinted that the clock_out field should be set a default value，when i set a default value , it succeed .

mysql version is 8.0.18 . I want to know why it occured ,can you help me?
the script is SQL案例分析-员工考勤记录

[dongxuyang1985]

I test with MySQL 8.0.27, without this issue.

The error 1067 means clock_out has an invalid defualt value, but the script doesn't set it.
does it has NO_ZERO_IN_DATE,NO_ZERO_DATE in sql_mode?
the first timestamp (without NULL or DEFAULT) will automatically has DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP, but other timestamp (without NULL or DEFAULT) will automatically has DEFAULT ‘0000-00-00 00:00:00’, will break the NO_ZERO_IN_DATE,NO_ZERO_DATE rule, and raise 10067 error.

This should be an Mysql bug, so it's fixed in new version.

[littleLi-star7]

thanks sql_mode has NO_ZERO_IN_DATE,NO_ZERO_DATE and i know why