What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type
do?



What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?..

Answer / amith

On initialization places a zero in that column, on future
updates puts the current value of the timestamp in.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More MySQL Interview Questions

How does mysql clustering work?

0 Answers  


Is mysql connect deprecated?

0 Answers  


Why do we use pragma autonomous transaction?

0 Answers  


How to get last inserted id after insert data from a table in mysql?

0 Answers  


Why mysql is used with php?

0 Answers  






How to define numeric 9(3) in db2 table without decimal point??

0 Answers  


Why mongodb is faster than mysql?

0 Answers  


What is user in mysql?

0 Answers  


What are the differences between char and varchar data types?

0 Answers  


Does mysql automatically index foreign keys?

0 Answers  


How to declare variable in mysql trigger?

0 Answers  


What is diff b/w MYISAM and INNODB storage engine. and also define the benifits and drawbacks of both storage engine

1 Answers  


Categories