#1067 - Invalid default value for 'LastUpdated'

Asked Mar 02 '15 at 05:18

Active Jul 11 '17 at 13:14

Viewed 1,301 times

I made my ER diagram via MySQL WorkBench and exported it as a sql. Below is code for one table.

CREATE TABLE IF NOT EXISTS `xxx`.`Agent` (
  `idAgent` INT NOT NULL AUTO_INCREMENT,
  `Name` VARCHAR(100) NOT NULL,
  `RegistrationNumber` VARCHAR(45) NOT NULL,
  `RegistrationDate` DATE NULL,
  `DateOfDealStart` DATE NULL,
  `AddressLine1` VARCHAR(100) NULL,
  `AddressLine2` VARCHAR(100) NULL,
  `Country` VARCHAR(45) NULL,
  `CurrentStatus` TINYINT(1) NOT NULL,
  `DateCreated` TIMESTAMP NOT NULL,
  `LastUpdated` TIMESTAMP NOT NULL,
  PRIMARY KEY (`idAgent`))
ENGINE = InnoDB;

However when I am trying to import the script into MySQL via PhpMyAdmin, it says below.

#1067 - Invalid default value for 'LastUpdated'

I have not provided any default value, so how can it could be "Invalid"?

edited Jul 11 '17 at 13:14

halfer

19,824
17
99
186

asked Mar 02 '15 at 05:18

PeakGen

21,894
86
261
463

try the answer here: http://stackoverflow.com/questions/9005766/invalid-default-value-for-dateadded – Taryn East Mar 02 '15 at 05:21
1

@TarynEast: He has already provided a `default value` – PeakGen Mar 02 '15 at 05:22
Note: I got the above by googling "1067 Invalid default value for date" – Taryn East Mar 02 '15 at 05:22
Fair enough. i didn't spot that – Taryn East Mar 02 '15 at 05:23
Maybe you have to provide a default? – Taryn East Mar 02 '15 at 05:24
@TarynEast: Maybe, but why? – PeakGen Mar 02 '15 at 05:25
Looks like this one has no provided default: http://stackoverflow.com/questions/27076899/error-1067-invalid-default-value-for-enddate (and an explanation of why it's a problem) – Taryn East Mar 02 '15 at 05:26
And another one, just in case that's not it :) http://stackoverflow.com/questions/23312144/error-error-1067-invalid-default-value-for-on-update-current-timestamp – Taryn East Mar 02 '15 at 05:37
no such error is generated when using rextexter.com – xQbert Jul 11 '17 at 13:18

#1067 - Invalid default value for 'LastUpdated'

0 Answers0