dongmei9961 2016-02-05 07:43
浏览 65

PostgreSQL PHP最后一个id值从不同的表到另一个表

Im trying to create a table which only will have the serial and 9 int foreign keys.

Is there a way to insert the last id from other tables to this table? i been trying with RETURNING, nextval()-1, currval(),ordering results by timestamp but nothing seems to work, i just cant get the ids values from the other tables inserted into the table. even tried this simple set of queries for each table to update one by one of the table columns

  $lst="SELECT id from table1 ORDER BY timestamp DESC limit 1";
  $lst_res=pg_query($conn,$lst);
$sql_eq_bat_up="UPDATE table9 set table1_id='$lst_res[id]'";
  $do_up_tbl1=pg_query($conn,$sql_eq_bat_up);

i been doing some research but had no luck, im using postgreSQL 9.5 and php for this, i hope you can help me thanks.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Oracle中如何从clob类型截取特定字符串后面的字符
    • ¥15 想通过pywinauto自动电机应用程序按钮,但是找不到应用程序按钮信息
    • ¥15 MATLAB中streamslice问题
    • ¥15 如何在炒股软件中,爬到我想看的日k线
    • ¥15 51单片机中C语言怎么做到下面类似的功能的函数(相关搜索:c语言)
    • ¥15 seatunnel 怎么配置Elasticsearch
    • ¥15 PSCAD安装问题 ERROR: Visual Studio 2013, 2015, 2017 or 2019 is not found in the system.
    • ¥15 (标签-MATLAB|关键词-多址)
    • ¥15 关于#MATLAB#的问题,如何解决?(相关搜索:信噪比,系统容量)
    • ¥500 52810做蓝牙接受端