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

How to dump one database for backup.

925

How do I change a procedure in mysql?

980

How many columns is too many mysql?

879

What does schema mean?

924

Is sqlite faster than mysql?

910

What is the role of a limit in a mysql query?

993

explain GROUPBY & HAVING clause with examples.

2272

Does mysql automatically index foreign keys?

902

Where is the mysql data directory?

914

What is a delimiter in mysql?

1002

What is the use of count function in mysql?

1012

How to install mysql?

1003

How do I change the max connection in mysql?

938

How do I delete a row in mysql?

929

How many ways we can retrieve the date in result set of mysql using php?

1101