dongzhenshen7435 2018-06-14 11:39
浏览 629
已采纳

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

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)
  • 写回答

1条回答 默认 最新

  • dongtong848825 2018-06-14 11:49
    关注

    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

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 电脑开机过商标后就直接这样,求解各位
  • ¥15 mysql , 用自己创建的本地主机和用户名 登录不上
  • ¥15 关于#web项目#的问题,请各位专家解答!
  • ¥15 vmtools环境不正常
  • ¥15 请问如何在Ubuntu系统中安装使用microsoft R open?
  • ¥15 jupyter notebook
  • ¥30 informer时间序列预测
  • ¥20 SSR引物多态性分析
  • ¥15 大漠插件在Win11易语言注册调用和免注册灵异事件,VS上注册调用完全没问题
  • ¥15 Addressable缓存机制做热更新的问题