Find freelancers. Lose those costly delays.

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

or, Register with Elance »

MySQL Query Needed (Simple job for MySQL pro)
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.


Job Description

  |  Change History >>


  • Posted: Sun, Aug 12, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    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: About $20
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I need prices updated in a MySQL table. There are 4 tables involved. The value in one table needs to be updated by joining the other 3 and taking the minimum value. I don't know how to do this in MySQL without creating a temporary table and have multiple steps in a PHP script. I'm sure a MySQL pro would easily know how to do this with one query.

I'll send a mysqldump of the database so you can complete job.


Sign in or Register to see more

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

 Armenia  |  
More than 7 years of work experience in PHP web development and C# .NET desktop applications development. Over 2 years of work experience with...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32675340  |  Submitted: Aug 12, 2012 11:45 ET 
Proposal SEALED

Happy to work with you in any of these web technologies: Laravel 4, Codeigniter, Wordpress, RESTful Web Services (REST APIs), PHP, MYSQL and use...
 0.0   |  Private   |  1 Jobs
Bid ID: 32675307  |  Submitted: Aug 12, 2012 11:42 ET 
Within 1 day
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »