php - Mysql多时间戳列更新

Question

考虑一下:

    +---------------+--------------+------+-----+-------------------+-----------------------------+
    | 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              |                             |
    +---------------+--------------+------+-----+-------------------+-----------------------------+

使用 PHP，如何让 optin_date 和 optout_date 列存储当前时间戳？

Answer 1

您只能有一个 current_timestamp 列。其次，您必须在插入/更新时使用触发器。

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