Re: Additive UPDATE

2003-11-05 Thread Héctor Villafuerte D.
Héctor Villafuerte D. wrote: Hi all! I need to perform what I've called an additive UPDATE. The logic is the next: (1) There's a historic table (HISTORY) with two fields: mysql create table history (ID char(7) primary key, VAL int(12)); (2) There's a new table everyday (TODAY) with exactly

Additive UPDATE

2003-11-03 Thread Héctor Villafuerte D.
Hi all! I need to perform what I've called an additive UPDATE. The logic is the next: (1) There's a historic table (HISTORY) with two fields: mysql create table history (ID char(7) primary key, VAL int(12)); (2) There's a new table everyday (TODAY) with exactly the same structure as HISTORY (ID