mysql - 作为连接查询插入后如何获取最大值

Question

INSERT INTO `idt_lookup`(`idt_resources`, `idt_lookup_name`, `idt_lookup_tbl_name`, `idt_lookup_key_col`, `idt_lookup_val_col`, `last_upd_by`, `last_upd_datetime_utc`) VALUES ('" + resourceId + "','" + roltbl + "','" + roltbl + "','" + rolid + "','" + rolname + "','1','" + date1 + "')

SELECT MAX(`idt_lookup_id`) AS maxid FROM `idt_lookup

我如何加入这两个查询。这可能吗？

Answer 1

尝试示例查询:-

$insertQuery = "
    INSERT INTO owner_business_media
        (business_id, sequence, type, filename, title, secret)
    SELECT
        '".intval($_GET['businessid'])."',
        (SELECT MAX(obm.sequence)+1 FROM owner_business_media obm WHERE obm.business_id=".intval($_GET['businessid']).") AS next,
        '$type', 
        '$fullfile', 
        '$filename', 
        '1'
";

希望这会有所帮助......!!