Timestamp automatically update with current date

Navigation
3

I would like to know if it is possible to automatically update the value of another TIMESTAMP column called date with the current date and time, similar to% the INSERT function of MySQL?

    
asked by anonymous 03.01.2015 / 21:00

1 answer

4

guys I got it with the simple sql command below. Thank you all 

ALTER TABLE 'grade_edt' CHANGE 'data_ultima_mod' 
'data_ultima_mod' DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;
    
03.01.2015 / 23:29
How to make a cursor to overlap a chart? Functions PHP + MySQLi