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

Which is faster mongodb or mysql?

843

How many columns can a mysql table have?

851

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1081

How can you import tables from a sql file into a database by using the mysql client?

966

what is database black box testing? : Mysql dba

1060

How do I clear the screen in mysql?

948

Why we use mysqli instead of mysql?

1011

What is the limitation of mysql?

908

What is the data source name for mysql?

889

How do I show all mysql databases?

923

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

840

How to display odd rows in student table in mysql?

929

What is the difference between mysql and oracle?

922

What is a select query?

813

What is the maximum no of columns a table can have?

866