php - 在 mysql 中插入带有 WHERE 条件的查询

Question

我尝试使用某些 where 条件将数据插入到 mysql 表中。但它会产生一些错误，即

error on queryYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE 

---

我试过以下查询，

if(isset($_POST['submit'])){
    $type=$_POST['leave_type'];
    $division=$_POST['division'];
    $number_of_date=$_POST['number_of_date'];

    $resul=mysql_query("SELECT * from employee where (division='$division' || division='all_dpt')") or die("query error".mysql_error());
    $result3 = mysql_fetch_array($resul);
    $emp_division=$result3['division'];
    $id=$result3['emp_id'];
    $annual_additional=$result3['annual_additional'];

    $value=$annual_additional+$number_of_date;

    if(($division==$emp_division || $division='all_dpt') && $type='Annual'){
        $result1=mysql_query("INSERT INTO employee (annual_additional) VALUES ('$value') WHERE emp_id='$id'")or die("error on query".mysql_error());
    }}

---

我该如何解决，请帮忙!

Answer 1

您不能使用INSERT.....WHERE，要更新一行您需要UPDATE....WHERE。

如果您有需要插入的条件，并且 key 不存在，则使用给定的示例。

演示示例:

INSERT INTO Users (id, weight, desiredWeight) VALUES(1, 160, 145) ON DUPLICATE KEY UPDATE weight=160, desiredWeight=145

收集自: MySQL Insert Where query