MySQL Forums
Forum List  »  InnoDB

Re: Invalid default value
Posted by: Tim Bomgardner
Date: August 15, 2014 10:39PM

I believe the column is NOT NULL. From 11.3.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME:


TIMESTAMP Initialization and the NULL Attribute

By default, TIMESTAMP columns are NOT NULL, cannot contain NULL values, and assigning NULL assigns the current timestamp. To permit a TIMESTAMP column to contain NULL, explicitly declare it with the NULL attribute.

Options: ReplyQuote


Subject
Views
Written By
Posted
2840
August 13, 2014 12:34PM
994
August 13, 2014 12:40PM
1667
August 13, 2014 01:01PM
1316
August 13, 2014 02:12PM
871
August 14, 2014 11:31AM
925
August 14, 2014 12:29PM
923
August 14, 2014 02:43PM
845
August 15, 2014 09:58PM
Re: Invalid default value
1415
August 15, 2014 10:39PM
888
August 16, 2014 05:15AM
979
August 16, 2014 07:56AM
862
August 16, 2014 05:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.