Insert into table select * ... union

Hello, I'm collecting data into a very simple table with one varchar(100) field ("myValue") and one int(10) field ("Qty"). I'm doing this with a simple "insert into . on duplicate key update qty = qty +1". After the table has reached a count of several 10 million records every insert takes

Re: insert into table select ...

Gaspar Bakos <[EMAIL PROTECTED]> wrote: > > I am trying to duplicate a row of a table in the following way: > > insert into Observer select * from Observer where OBid = 4; > ERROR 1066: Not unique table/alias: 'Observer' > > It is a unique table; I mean there can't be another table named in the

insert into table select ...

Hi, I am trying to duplicate a row of a table in the following way: insert into Observer select * from Observer where OBid = 4; ERROR 1066: Not unique table/alias: 'Observer' It is a unique table; I mean there can't be another table named in the same way. Any pointer would be welcome. Probably