How to update MySql timestamp column to current timestamp on PHP?

Question

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

Can you please tell me how to do that?

Does it have to be the PHP timestamp instead of mySQL's `NOW()`? — Pekka, May 03 '11 at 12:27

score 89 · Accepted Answer · edited Apr 10 '17 at 22:30

89

Use this query:

UPDATE `table` SET date_date=now();

Sample code can be:

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

mysql_query("UPDATE `table` SET date_date=now()");

mysql_close($con);
?>

edited Apr 10 '17 at 22:30

xeruf

2,602
1
25
48

answered May 03 '11 at 12:27

Harry Joy

58,650
30
162
207

when we talk about timestamp, we usually mean GMT. this will give date with server time zone. – Ali Faizan Apr 22 '14 at 22:21

score 20 · Answer 2 · answered Sep 26 '14 at 18:33

20

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().

answered Sep 26 '14 at 18:33

Madbreaks

19,094
7
58
72

7

Should not be fast, as according this (https://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html) it's just a synonym for now() – Jimmy Koerting Jun 21 '15 at 12:34

How to update MySql timestamp column to current timestamp on PHP?

2 Answers2