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

Answer Posted / amith

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

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many entries can mysql handle?

504


What is meant by sharding?

500


How To see all the tables from a database of mysql server.

579


What is the difference between unix timestamps and mysql timestamps?

514


What is the datatype of image?

513






How to find the unique values if the value in the column is repeated?

560


How do I clear the screen in mysql?

526


How can you make a database as your current database?

508


1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

1938


What is mysql procedure?

511


What is the use of mysql_fetch_array () function in php?

473


Can you tell the difference between $message and $$message?

533


How to Set a root password if there is on root password.

590


How to present a past time in hours, minutes and seconds?

552


How to declare variable in mysql trigger?

489