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 are queries used for?

496


What is maximum table size in mysql?

473


What is mysql uuid?

521


What is ibdata1?

501


How to set the time zone for MySQL to particular country time?

2718






What is database migration in mysql?

512


How to delete a table.

507


Is mysql is a programming language?

517


How to validate email addresses in mysql?

594


What is a tinyint?

503


What is the difference between myisam dynamic and myisam static in mysql?

491


How to enter boolean values in sql statements?

535


Is mysql a dbms?

481


How do you restart mysql?

473


Is sql similar to mysql?

475