Check the REPLACE command...
http://www.mysql.com/doc/en/REPLACE.html
I think it suits your problem...
On Mon, 2003-01-20 at 08:14, Michael Watson wrote:
> This may be very simple, but the solution eludes me..
>
> I have two tables Products and NewProducts, The Products table contains a
> list
This may be very simple, but the solution eludes me..
I have two tables Products and NewProducts, The Products table contains a
list of all the current product line and prices Products.ProdCode,
Products.Price (amongst other details not relevent here). NewProducts
contains a list of changes to
