Mysql multiple timestamp column update

Question

Consider this:

    +---------------+--------------+------+-----+-------------------+-----------------------------+
    | Field         | Type         | Null | Key | Default           | Extra                               |
    +---------------+--------------+------+-----+-------------------+-----------------------------+
    | email_address | varchar(100) | NO   | PRI | NULL              |                             |
    | create_date   | timestamp    | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
    | optin_date    | timestamp    | YES  |     | NULL              |                             |
    | optout_date   | timestamp    | YES  |     | NULL              |                             |
    +---------------+--------------+------+-----+-------------------+-----------------------------+

Using PHP, how can I make the optin_date and optout_date columns store the current timestamp?

Haven't really tried anything yet. I have this so far: update table set optin_date = now(). Any thoughts? — Simon
– Simon, Commented Jan 4, 2012 at 7:51
Why do you need to have some 'timestamp on update CURRENT_TIMESTAMP' fields? They will have the SAME values after UPDATE. — Devart
– Devart, Commented Jan 4, 2012 at 8:54
Similar question (see the comments) - stackoverflow.com/questions/5592049/… — Devart
– Devart, Commented Jan 5, 2012 at 8:09

Peter Krejci · Accepted Answer · 2012-01-04 07:41:52Z

3

You can have only one current_timestamp column. For the second you have to use trigger on insert/update.

http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html

answered Jan 4, 2012 at 7:41

Peter Krejci

3,2126 gold badges34 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

Mysql multiple timestamp column update

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related