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

Question Posted / amith

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

Answer / amith

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

Is This Answer Correct ?

7 Yes

1 No

More MySQL Interview Questions

Why we use mongodb instead of mysql?

How can an index be declared in mysql?

What?s the difference between query_cache_type 1 and 2?

Is blocked because of many connection errors mysql?

What is the purpose of mysql database?

Does adding an index lock a table?

Can not connect to mysql server 10060?

How does triggers work in mysql?

What is meant by mysqli?

How to create a table?

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

What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

For more MySQL Interview Questions Click Here