What does TIMESTAMP ON UPDATE CURRENT

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type
do?

Question Posted / amith

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

More MySQL Interview Questions

What is processlist in mysql?

In the below example, how many String Objects are created? String s1="I am Java Expert"; String s2="I am C Expert"; String s3="I am Java Expert";

what is the difference between gui testing and database testing? : Mysql dba

What is the maximum size of table in mysql?

How can you take the backup and restore a mysql database using php?

What is the difference between primary and unique key

how many ways we can get the current date in mysql?

is it possible to assign two primary key in a table

What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

Where is the mysql data directory?

What is difference between oracle and mysql?

how to connect a php script with the mysql database?

For more MySQL Interview Questions Click Here