List:General Discussion« Previous MessageNext Message »
From:Scott Haneda Date:October 4 2007 4:35am
Subject:single line inserts with on duplicate key
View as plain text  
Is it possible, in single-line inserts, with on duplicate key clauses, to
get back a list of last insert id's for what was inserted?

I get strange results, just one single insert id, which makes sense from the
perspective of what was just inserted, however, I need to know what the
returned insert id is for each of an arbitrary amount of single-line
inserts.

Defining what I am calling single line insets, I mean:
INSERT INTO foo (a, b, c) VALUES ('x', 'y', 'x'), ('x', 'y', 'x'), ('x',
'y', 'x'), etc etc
-- 
-------------------------------------------------------------
Scott Haneda                                Tel: 415.898.2602
<http://www.newgeo.com>                     Novato, CA U.S.A.


Thread
single line inserts with on duplicate keyScott Haneda4 Oct
  • Re: single line inserts with on duplicate keyBaron Schwartz4 Oct