List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:October 4 2007 10:17am
Subject:Re: single line inserts with on duplicate key
View as plain text  
Scott Haneda wrote:
> 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

I know of no way to do this.

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