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

How do you insert a table?

873

Where is mysql password stored?

871

What is prepared statement in mysql?

900

What is the difference between unix timestamp and mysql timestamp?

993

Can you tell the difference between ereg_replace() and eregi_replace()?

982

How are mysql timestamps seen to a user?

941

How to returns the columns and column information pertaining to the designated table.

972

How to enter numeric values as hex numbers?

928

Who owns mysql database?

986

How to run 'mysql' commands from a batch file?

965

How do I view data in mysql workbench?

950

Is oracle mysql free?

820

How we can get distinct columns values in mysql?

1012

Is mysql same as sql?

838

How to run a sql statement?

961