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. > -----Original Message----- > From: Votteler Marc [mailto:[EMAIL PROTECTED]] > 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 know which DBMS is being used > (one of Oracle, MS SQL and mySQL), I can not discern if it was a > 'real' error or just the fact that the record already exists. > > 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 > > 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? > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
