On initialization places a zero in that column, on future updates puts th

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type
do?

Question Posted / amith

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

Please Help Members By Posting Answers For Below Questions

Is mysqli deprecated?

903

Can we store videos in mysql database?

883

Define REGEXP?

1051

How do I create a database in mysql workbench?

834

How to get data from mysql in php?

854

How to start mysql server?

1004

What is int mysql?

898

How we can create index in mysql?

934

How do I rename a table in mysql workbench?

917

Why is mysql popular?

834

Where is the mysql data directory?

891

what is constraints?

1081

How can we find out which auto increment was assigned on Last insert?

1048

Write a query to fetch duplicate records from a table using mysql?

892

Is mysql a scripting language?

858