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 many rows can mysql handle?

940

What storage engines are used in MySQL?

1052

Is mariadb better than mysql?

1041

What are the differences between mysql vs sql server?

1057

table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

1365

What is text?

968

What is 1nf 2nf 3nf?

983

What is striped backup

2244

What is deterministic in mysql?

980

What is the full meaning of mysql?

969

How do I tune a mysql query?

895

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

930

What is the use of mysqli_query?

885

What are the 5 r's of managing behaviors?

1089

How to increment dates by 1 in mysql?

1034