An error was reported in the process of importing the table from mysql5.7: [err] 1067 – invalid default value for ‘***‘

It is said on the Internet that my.ini or my.cnf files should be changed so that they can be used. I didn’t use them. I used the following method

My problem is that when creating database tables visually, I choose timestamp as the data type and report an error

solution: add current to the default value_ The value of timestamp can be from 10:00:00 on January 1, 1970 to 23:59:59 on December 31, 2037


Read More: