That field gets the current timestamp whenever the row gets altered.

What happens if a table has one column defined as TIMESTAMP?

Question Posted / amith

Answer Posted / amith

That field gets the current timestamp whenever the row gets
altered.

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What does tinyint mean?

975

How to write after insert event update trigger on the same table in mysql?

1006

How many threads can mysql handle?

1041

What is select query in mysql?

968

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4720

What is the hostname for mysql database?

1073

How to start mysql server?

1103

What is pragma autonomous_transaction?

926

What is the datatype for password in mysql?

1034

how to Return total number of rows.

1062

How to create a new view in mysql?

970

What is a crosstab query?

1013

How do I view a mysql database?

951

How to create a trigger in mysql?

981

How to use like conditions?

1044