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
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
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
same