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 not null is not allowed at table level

how to dump all databases for backup. Backup file is sql commands to recreate all db's.

What is key in mysql?

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

In mysql, what is the default storage engine?

How do I drop a database in mysql?

How to rename an existing table in mysql?

How does mysql store data?

How to print message in mysql trigger?

What is the purpose of -> in the mysql terminal?

What are the advantages of MySQL when compared with Oracle?

What are the functions in mysql?

For more MySQL Interview Questions Click Here