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 do you mean by % and _ in the LIKE statement?

545


How to convert numeric values to character strings?

524


How do I view mysql logs?

493


How set mysql root password?

494


What is data types in mysql?

486






How to use regular expression in pattern match conditions?

526


How can you filter the duplicate data while retrieving records from the table?

478


What is innodb_buffer_pool_size?

472


How many groups of data types?

523


Why to use char instead of varchar in the database?

571


What is blob in mysql?

501


What is difference mysql and mysqli?

517


How to get data from mysql in php?

438


How do I find the database name in mysql?

518


How will show all records containing the name "sonia" and the phone number '9876543210'

527