Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .

Answer Posted / prasanna shejwal

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

CURRENT_TIMESTAMP :- when row get inserted that time current
timestamp get inserted. No change on update.

ON UPDATE CURRENT_TIMESTAMP :- when row get updated that
time current timestamp get inserted. On inserted default
value get inserted

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can I use mariadb instead of mysql?

682


Will mysql remain free?

714


Which mysql function is used to concatenate string?

1072


What is procedure in mysql?

692


What is mysql community edition?

711


1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

2170


Is mysql a dbms?

653


What is a tinyint?

717


Which is faster innodb or myisam?

729


What is the difference between mysql_fetch_assoc and mysql_fetch_array?

724


Why should I learn mysql?

693


What is difference between mysqli and pdo?

667


How to make a copy values from one column to another in mysql?

811


What is msql?

736


Is mysql easy to learn?

693