I have two CSV's which I've imported into mySQL. I need a script that will do the following..
1) Match two conditions which appear in both tables (Customer name and product)
2) Pull two predefined columns from one of the tables (cost price and quantity)
3) Import these into the first table to replace an existing quantity and cost price column.
4) Repeat for every line/product in the databases
The purpose is to bring data from a third party supplier into the database we use to bill customers.
January 30, 2018
I am looking for a mix of experience and value