mysql 更新最后插入的 id

本文介绍了mysql 更新最后插入的 id的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我想通过获取最后插入的 id 来更新表，但它没有给出任何结果.这是查询:

$quer = mysql_query("更新日期SET d_startdate = '$start', d_enddate = '$end'WHERE d_id = LAST_INSERT_ID() AND d_sid = $id");

d_id 是主键，d_sid 是另一个表的外键

解决方案

我在同一张表上使用了 INSERT 和 UPDATE 操作，并且工作正常.您可以根据需要更改此查询.

<?php$con = mysql_connect("localhost","root","") or die("无法连接");mysql_selectdb("test", $con);$query = 'INSERT INTO item (`name`) VALUES ("DELTaaaA")';$res = mysql_query($query, $con) 或 die(mysql_error());echo "

";打印_r($res);$query = '更新项目集名称="DELTaaaA1" WHERE id = LAST_INSERT_ID()';$res = mysql_query($query, $con) 或 die(mysql_error());打印_r($res);?>

它应该返回 1 1

I want to update a table by getting the last inserted id but it is giving no results. here is the query :

$quer = mysql_query("UPDATE date SET d_startdate = '$start', d_enddate = '$end' WHERE d_id = LAST_INSERT_ID() AND d_sid = $id");

d_id is the primary key and d_sid is a foreign key of another table

解决方案

I have used INSERT as well as UPDATE operation on my same table and its working fine. You can change this query as per your need.

<?php $con = mysql_connect("localhost","root","") or die("Could not connect"); mysql_selectdb("test", $con); $query = 'INSERT INTO item (`name`) VALUES ("DELTaaaA")'; $res = mysql_query($query, $con) or die(mysql_error()); echo "<pre>"; print_r($res); $query = 'UPDATE item set name="DELTaaaA1" WHERE id = LAST_INSERT_ID()'; $res = mysql_query($query, $con) or die(mysql_error()); print_r($res); ?>

It should return 1 1