The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I need a query or queries made to format a .csv file in order for me to upload the output/results to a live server properly..
1) This must be in mysql only
2) I would like a query made to show me the products that are in the todays.csv(recently downloaded) compared to the old yesterdays.csv(downloaded prior).. e.g products NOT IN new todays.csv but in old yesterdays.csv file.
3) I have 2 tables locally that i use in order to update the live table. 1 i download the new today.csv to and another i would have the old yesterday.csv file in. I run queries to tell me what has changed e.g what prices have changed between yesterday and today, if a product is no longer available, how many products are new and not in yesterdays.csv file what quantity have decreased or increased etc.
Sign in or Register to see more