When creating a table, a field is non-empty timestamp, timestamp NOT null problem comes, when using Workbench to build a table, if the value is not empty, you need to have a default value, otherwise it will be an error. Then, if auto-population is updated with the default on update Current_timestamp, and inserted only at INSERT, Current_timestamp is used if not updated; The problem is, if you don't want to use Current_ Timestamp how to do mud? ' End_time ' timestamp not NULL DEFAULT ' 0000-00-00 00:00:00 ', this is a statement from the terminal's Show create TABLE (stole a lazy, using the visual tools to build the table), but the strange question is, This statement, CL mode can run very well, but in the workbench is not able to run, checked for half a day did not find the reason. PS: In addition, a table can not have more than one place to use Current_timestamp as the default value, this is the use of MySQL, and Workbench Independent.
The strange things in Mysqlworkbench. Timestamp default value of non-null