mysql - SQL更新到插入

Question

$stmt = $db->prepare("UPDATE reservations SET name = :name, start = :start, end = :end, room_id = :room, status = :status, paid = :paid, customer = :customer, name_ship = :name_ship, equipment = :equipment, port = :port, ETA = :ETA, ETD = :ETD, service_id = :service_id, service_classification = :service_classification, job = :job WHERE id = :id");

嗨!我有这个查询，我想将其转换为 INSERT 格式。当我这样做时，什么也没有发生。谢谢你的建议

"INSERT INTO reservations (name, start,...) VALUES (:name, :start,...) WHERE id = :id"; 

Answer 1

由于您正在执行 INSERT，因此您应该删除 WHERE 子句。

例如

INSERT INTO reservations (name, start,...) VALUES (:name, :start,...)