So I have a table of data in my db with multiple columns. Essentially they are product codes, prices and information on the product. As with all sales people I need to be able to change the prices regularly to reflect supplier price or margin increases or decreases.
So I need to be able to import from excel or csv my new prices. I do not want to create new records for the same product, just update existing product.
Is there anyone out there who know how to do this using Toad for MySQL?