Mysql timestamp default value

Question

Am really new to Mysql. Is it possible to do something like the following in some way? Mysql throws a syntax error as expected but is there something that I should change that would make it work?

CREATE TABLE tracksession(ID INT NOT NULL AUTO_INCREMENT,
             user_id INT DEFAULT NULL,
             leave_mode ENUM('loggedout', 'timedout') DEFAULT NULL,
             login TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
             logout TIMESTAMP DEFAULT ADDDATE(CURRENT_TIMESTAMP, INTERVAL 20 MINUTE),
             PRIMARY KEY(ID));

Thanks in advance.

Manse · Accepted Answer · 2012-04-19 09:02:01Z

6

Nope you cannot do this

DEFAULT ADDDATE(CURRENT_TIMESTAMP, INTERVAL 20 MINUTE),

explanation from the manual :

The DEFAULT value clause in a data type specification indicates a default value for a column. With one exception, the default value must be a constant; it cannot be a function or an expression.

Must be a constant not a function ...

edited Apr 19, 2012 at 9:02

answered Apr 19, 2012 at 8:52

Manse

38.1k11 gold badges88 silver badges112 bronze badges

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

Collectives™ on Stack Overflow

Mysql timestamp default value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related