我正在用PHP编写mySQL查询.我想在数据库的表中复制一行.我还想插入一个时间戳,以了解NOW()函数何时发生重复.
如果我有一个名为“ people”的表,其中包含以下字段:
id, name, phone, dateCreated
我想复制此记录,请执行以下操作:
INSERT INTO people (id, name, phone, dateCreated)
SELECT id, name, phone, dateCreated
FROM people
WHERE id = '$id'
这将复制$id标识的记录.我想执行相同的概念,但是我不想复制dateCreated,而是希望查询通过NOW()函数插入当前日期时间,但是我不确定如何构造这种类型的查询.
就像是:
INSERT INTO people (id, name, phone)
SELECT id, name, phone
FROM people
WHERE id = '$id'
(dateCreated) value (NOW())
我将如何构造查询?
解决方法:
INSERT INTO people (id, name, phone, dateCreated)
SELECT id, name, phone, NOW()
FROM people
WHERE id = '$id'
标签:mysql,php
来源: https://codeday.me/bug/20191209/2095426.html