如何手动将时间戳插入mySQL数据库？

Question

I want to manually be able to insert a timestamp value to mySQL database:

  $timestamp = "2018-05-15 00:00:00";
  $name = "Fred";


  $pdo = $db->prepare('INSERT INTO data (timestamp,name) values(:timestamp,:name)');
  $pdo->execute(array(
       ':timestamp' => $timestamp,
       ':name' => $name
  ));

But it inserts always the date of now, not the date of my variable.

MYSQL table:

id | timestamp | name
----------------------
   |           |


id = int(11) AUTO_INCREMENT
timestamp = timestamp (Standard: CURRENT TIMESTAMP, Attribute: ON UPDATE CURRENT TIMESTAMP)
name = varchar (255)

Answer 1

If you want to manually insert date in timestamp field then you should change its type from timestamp (Standard CURRENT TIMESTAMP) to datetime. Only then it will work, otherwise always it save current system time.

Read more about datetime