Last modified Timestamp in MySQL

The default value of the column should be the one a开发者_如何学Pythont the time of insertion and later when updation or deletion is done it should change in my sql

You probably want to set these properties on the field:

    DEFAULT CURRENT_TIMESTAMP 
    ON UPDATE CURRENT_TIMESTAMP;