CODEWITHSUNDEEP
mysql
PHP
PHP

Reputation: 443

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

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 .

Upvotes: 0

Views: 150

Answers (1)

cegfault
cegfault

Reputation: 6632

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

Upvotes: 2

Related Questions