Author: Prasanna Shejwal

Difference between TIMESTAMP DEFAULT, CURRENT_TIMESTAMP, ON UPDATE CURRENT_TIMESTAMP in MYSQL

Difference between TIMESTAMP DEFAULT, CURRENT_TIMESTAMP, ON UPDATE CURRENT_TIMESTAMP in MYSQL

By | | Comments 2 comments

TIMESTAMP DEFAULT :- in this when new row get inserted or existing row get updated that time current timestamp get inserted.

CURRENT_TIMESTAMP :- in this when row get inserted that time current timestamp get inserted.no change on update.

ON UPDATE CURRENT_TIMESTAMP :- when row get affected that time current timestamp get inserted.

Regards

Prasanna Shejwal