Mysql Error Code: 1067 two timestamp column

Question

CREATE TABLE IF NOT EXISTS `xyz` (
   `id` INT(11) NOT NULL AUTO_INCREMENT ,
   `start_time` TIMESTAMP NOT NULL,
   `end_time` TIMESTAMP NOT NULL,
   PRIMARY KEY (`id`) ) 
 ENGINE = InnoDB;

Running the above mysql script results in: Error Code: 1067. Invalid default value for 'start_time'. The error is most likely due to two TIMESTAMP column in one table

Similar answer to this question is vague. Invalid default value for 'create_date' timestamp field

I need a clear solution.

Blank · Accepted Answer · 2017-09-25 02:46:05Z

1

You've missed backticks ` before xyz:

CREATE TABLE IF NOT EXISTS `xyz` (
   `id` INT(11) NOT NULL AUTO_INCREMENT ,
   `start_time` TIMESTAMP NOT NULL,
   `end_time` TIMESTAMP NOT NULL,
   PRIMARY KEY (`id`) ) 
ENGINE = InnoDB;

answered Sep 25, 2017 at 2:46

Blank

12.4k1 gold badge16 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Tim Biegeleisen Over a year ago

Rather than answering such typo questions, just vote to close them.

Blank Over a year ago

@TimBiegeleisen Maybe not a typo question to OP, we can not suppose everyone would have been very familiar with mysql, and OP have tried to search answers, but he or she did not get it. Maybe I should take this answer as a comment, but I hold a reservation about voting to close.

sdfdsf sdf Over a year ago

@Forward Sorry about the typo, the error wasn't typo. The error is most likley due to two TIMESTAMP column in one table.

Collectives™ on Stack Overflow

Mysql Error Code: 1067 two timestamp column

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related