我想手动将时间戳值插入mysql数据库:
$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
));
但它总是插入现在的日期,而不是变量的日期。
mysql表:
id | timestamp | name
----------------------
| |
id = int(11) AUTO_INCREMENT
timestamp = timestamp (Standard: CURRENT TIMESTAMP, Attribute: ON UPDATE CURRENT TIMESTAMP)
name = varchar (255)
1条答案
按热度按时间1yjd4xko1#
如果要在时间戳字段中手动插入日期,则应将其类型从
timestamp (Standard CURRENT TIMESTAMP)
至datetime
. 只有这样它才能工作,否则总是可以节省当前的系统时间。阅读有关datetime的更多信息