mysql - 插入不存在的值

Question

我需要将数据插入到facility_details表中，但表中不存在，下面的代码无法正常运行。

$facility = $_POST["facilities_cb"];
foreach ($facility as $feature)
{
    mysqli_query($conn,"INSERT INTO facilities_details(facilitiestype_id,hotel_id) values ('$feature','$hid') WHERE NOT EXISTS (SELECT facilitiestype_id FROM facilities_details)");
}

Answer 1

没有这样的语法WHERE不能与INSERT一起使用。如果您想在数据存在时忽略INSERT，那么您可以使用INSERT IGNORE

INSERT IGNORE INTO facilities_details(facilitiestype_id,hotel_id)
VALUES ('$feature','$hid')