Mysql default null timestamp

Asked 4 years ago. Active 3 years, 6 months ago. Viewed 3k times. Is it possible to have a not nullable timestamp with no default value?

Improve this question. McNets Edmondo Edmondo 1 1 silver badge 5 5 bronze badges. How are you trying to insert new values? This is not at insert time, this is at table creation time: I cannot create the table — Edmondo You should be able: rextester , dbfiddle — McNets.

If strict SQL mode is enabled, an error occurs for transactional tables and the statement is rolled back. For nontransactional tables, an error occurs, but if this happens for the second or subsequent row of a multiple-row statement, the preceding rows are inserted. If strict mode is not enabled, MySQL sets the column to the implicit default value for the column data type. In this case, i has no explicit default, so in strict mode each of the following statements produce an error and no row is inserted.

When not using strict mode, only the third statement produces an error; the implicit default is inserted for the first two statements, but the third fails because DEFAULT i cannot produce a value:. See Section 5. For string types other than ENUM , the default value is the empty string. For ENUM , the default is the first enumeration value. Numeric Type Attributes. Out-of-Range and Overflow Handling. Date and Time Data Type Syntax.

MySQL 5. See other posts on this site for more details. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 7 years, 9 months ago. Active 1 year, 11 months ago. Viewed 21k times. I've just spent a couple of hours tracking down this bug.

Jonnny 4, 11 11 gold badges 59 59 silver badges 88 88 bronze badges. You probably want datetime instead of timestamp. With a constant, the default is the given value. In this case, the column has no automatic properties at all. The default in this case is type dependent. Specify the NULL attribute. The tables differ in how the ts1 column handles NULL values. For t3 , ts1 permits NULL but has an explicit default of 0.

This is permitted:. Suppose that tables t1 and t2 have these definitions:. For example:.