0

Operation failed: There was an error while applying the SQL script to the database. Executing:

CREATE TABLE `database1`.`log` (
  `rollnum` VARCHAR(45) NOT NULL,
  `checkout` TIMESTAMP(6) NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`rollnum`));

ERROR 1067: Invalid default value for 'checkout'
SQL Statement:
CREATE TABLE `database1`.`log` (
  `rollnum` VARCHAR(45) NOT NULL,
  `checkout` TIMESTAMP(6) NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`rollnum`))
Progman
  • 16,827
  • 6
  • 33
  • 48
Praveen
  • 1
  • 1
  • 1

1 Answers1

0

Your fractional precision should be consistent.

Replace

`checkout` TIMESTAMP(6) NULL DEFAULT CURRENT_TIMESTAMP

by

`checkout` TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6)
adarsh
  • 1,393
  • 1
  • 8
  • 16