Re: Additive UPDATE

2003-11-07 Thread "Héctor Villafuerte D."
Héctor Villafuerte D. wrote: 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));

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 e

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 t