Re: Re: Duplicating a mySQL row

Well, I skiped this manual part :-) Maybe the simple select and insert is the simplest form. -- Julio Nobrega Don't eat the yellow snow. "Jim" <jim@nettmedia.com> wrote in message news:p05101010b8318afec141@[192.168.1.17]... > > It appears that this is forbidden ... > > From mysql.com: > > The target table of the INSERT statement cannot appear in the FROM > clause of the SELECT part of the query because it's forbidden in ANSI > SQL to SELECT from the same table into which you are inserting. (The > problem is that the SELECT possibly would find records that were > inserted earlier during the same run. When using sub-select clauses, > the situation could easily be very confusing!) > > >