How to update MySQL timestamp column to current timestamp?

Question

I want to update the columns of data type timestamp manually through my PHP code.

How to do that?

Answer 1

Use this query:

UPDATE `table` SET date_date=now();

Answer 2

Another option:

UPDATE `table` SET the_col = current_timestamp

Looks odd, but works as expected. If I had to guess, I'd wager this is slightly faster than calling now().