> insert-select on the same table is not allowed in MySQL. If I remember
> right it isn't allowed in ANSI SQL either, supposedly because it
> could lead
> to infinite loops if implemented poorly.
>
> Jon Gardiner.
Core SQL support does not require the DBMS to support it; enhanced
SQL support a
ED]]
> Sent: Thursday, November 15, 2001 3:30 AM
> To: Rick Emery; [EMAIL PROTECTED]
> Subject: RE: INSERT with SELECT on same table
>
>
> Thanks for the response,
>
> you are right I would get an Exception describing that the record
> already exists, but because I do not k
sts.
marc
-Ursprüngliche Nachricht-
Von: Rick Emery [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 14. November 2001 19:46
An: Votteler Marc; [EMAIL PROTECTED]
Betreff: RE: INSERT with SELECT on same table
> If one of the table's fields is defined as UNIQUE or PRIMARY KEY, it will
>
If one of the table's fields is defined as UNIQUE or PRIMARY KEY, it will
allow the insertion only once with that key. When a second attempt is made
to insert the record with the same key, the insertion will be ignored and
you may ignore the error code that results.
Would that work for you?
---
