176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Formatting csv file in Mysql
Sign in to Add to Watch List

IT & Programming > Web Programming

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Aug 18, 2011

Job awarded.

Aug 8, 2011
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Tue, Jul 26, 2011
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

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

Desired Skills
MySQL Administration
Job ID: 25368338
 
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Ukraine  |  
Hi! My name is Pavel Ganzha, I'm from Kharkiv, Ukraine. In my work, I always adhere to the rule, "Treat the customer as I would like to be...
Skills: PHP5, PHP, AJAX
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 25400004  |  Submitted: Jul 27, 2011 17:20 ET 
Proposal SEALED

 United States  |  
I'm a talented and experienced PHP developer. I'm experienced with PHP 5, MySQL, Apache, CSS, W3C compliant XHTML, Javascript, Ajax, Flash,...
2
  |  
 0.0   |  $76 Earnings   |  1 Jobs
Bid ID: 25376648  |  Submitted: Jul 26, 2011 13:42 ET 
Proposal SEALED

 India  |  
We have a dedicated team of 50, experts in PHP/MySQL, HTML 5, CSS 3, HTML, Ajax, Wordpress, Joomla, Custom CMS, Ecommerce, Social Networking,...
2
  |  
 0.0   |  Private   |  0 Jobs   |  2 verified credential(s)
Bid ID: 25370641  |  Submitted: Jul 26, 2011 07:55 ET 
Proposal SEALED

 Pakistan  |  
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 25369608  |  Submitted: Jul 26, 2011 06:48 ET 
Proposal SEALED

 Vietnam  |  
I'm a php programer with two years experience. Sample page: http://educom.vn, bookdealfinder.com. I'm a system administrator also. I used linux for...
5
  |  
 5.0   |  $533 Earnings   |  11 Jobs
Bid ID: 25368901  |  Submitted: Jul 26, 2011 06:03 ET 
Proposal SEALED

 India  |  
* Strong in building bots / scraper / crawlers / spiders / harvesting program development. I can scrape from any website including those involves...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 25368873  |  Submitted: Jul 26, 2011 06:01 ET 
Proposal SEALED

 Egypt  |  
Winner
Do you have problems with your site? Do you need help fixing your site? The experts are here! Try our magic! We solve any web based problems,...
6
  |  
 0.0   |  Private   |  0 Jobs   |  1 verified credential(s)
Bid ID: 25368777  |  Submitted: Jul 26, 2011 05:53 ET 
Delivery
Within 3 days
$219.18

 Palestine  |  
Winner
Esolutions is a Professional web developement Team ,Our goal is to deliver the best quality with the best Cost , We have more than 5 years of...
1
  |  
 5.0   |  Private   |  2 Jobs
Bid ID: 25368684  |  Submitted: Jul 26, 2011 05:47 ET 
Delivery
Within 3 days
$250.00
Elance is now an Upwork company.
Upwork is the choise of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »