You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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案例分析-员工考勤记录
The text was updated successfully, but these errors were encountered:
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.
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案例分析-员工考勤记录
The text was updated successfully, but these errors were encountered: