How to update date,year and month to an existing table in mysql

Question

How to update the Current date ,month,year to an existing table,and when ever the data in the table is modified automatically date should be modified .

score 2 · Accepted Answer · edited May 23 '17 at 10:09

2

That is addressed in the MySQL documentation here: http://dev.mysql.com/doc/refman/5.0/en/timestamp-initialization.html

Also view these questions:

MySQL ON UPDATE CURRENT_TIMESTAMP not updating

MySQL CURRENT_TIMESTAMP on create and on update

edited May 23 '17 at 10:09

Community

1
1

answered Jul 19 '12 at 23:51

cegfault

6,442
3
27
49

How to update date,year and month to an existing table in mysql

1 Answers1