What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type
do?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mysql uuid?

610


What is the use of i-am-a-dummy flag in mysql?

634


What is myisam?

583


What is the datatype for password in mysql?

607


How do I backup mysql database on linux?

569






What is the purpose of using timestamp data type?

579


How can we convert between Unix & MySQL timestamps?

530


What is mysql good for?

552


Which is better sqlite or mysql?

578


What is mysql ndb?

601


How to use regular expression in pattern match conditions?

598


How to use 'mysql' to run sql statements?

611


In which year mysql created?

608


What is an example of a delimiter?

588


What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

660