本文介绍了插入后获取自动生成的 ID的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着跟版网的小编来一起学习吧！
问题描述
I have an Oracle Express 10g database. In my table I have an auto-generated ID and I would like to know how I can find what the generated ID is after an insert happens. I am currently using PHP.
解决方案
You can get the returning id into a variable. For example, this code:
$data = array("larry","bill","steve");
$db = OCILogon("scott","tiger");
$stmt = OCIParse($db,"insert into names values (myid.nextval,:name) returning id into :id");
OCIBindByName($stmt,":ID",$id,32);
OCIBindByName($stmt,":NAME",$name,32);
while (list(,$name) = each($data))
{
OCIExecute($stmt);
echo "$name got id:$id
";
}
This gives you the ID got by $name in form of the variable $id. Change your SQL accordingly.
这篇关于插入后获取自动生成的 ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！
本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益，请联系我们，我们会在确认后第一时间进行删除！