Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I published a UPDATE sentence in MySQL5.1, update is inapplicable, and the column of a certain current_timestamp type is updated by time when I carried out UPDATE. Will it be the data column which is updated even if current_timestamp type may not lack in UPDATE explicitly?

share|improve this question
up vote 1 down vote accepted

When you created the table you can setup the first TIMESTAMP column with both DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP clauses, the column has the current timestamp for its default value, and is automatically updated.

You can find more information on timestamp here:


share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.