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 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 be made to the database, ie New Product lines, > changes of prices to existing lines. (NewProducts.ProdCode, > NewProducts.Price). > > How can I update existing records in Products if ProdCode are equal in both > tables, and if ProdCode exists in NewProducts but Not in Products, insert > that records? > > We are using MySQL Version 3.23.54a > > Thanks > > Michael Watson > MBW Computing > [EMAIL PROTECTED] > Tel: 03 9782-0427 Fax: 03 9782-0657 > Mob: 0425 788-185 -- Diana Soares --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
