176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Complex Update Query Needed (Simple job for a 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.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Mon, Aug 13, 2012
  • 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: $20 - $50
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I need prices updated in a MySQL table. There are 4 tables involved. The price value in one table needs to be updated by correctly joining the other 3 tables 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.

Explaining again for clarity: There are multiple products in the main table that will need updating with this one query. Each product has multiple prices as related by the other tables. The product price should be updated to the minimum of these multiple prices.

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

Thanks.

Sign in or Register to see more

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

 Singapore  |  
I'm a dedicated programmer who offer quality service with reasonable budget.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32725003  |  Submitted: Aug 14, 2012 07:56 ET 
Proposal SEALED

 Pakistan  |  
EZoneLogic is a software development, system integration and technical writing service provider since 2008. We deliver innovative solutions for...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 32719466  |  Submitted: Aug 14, 2012 03:34 ET 
Proposal SEALED

 India  |  
ORACLE DBA
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32719134  |  Submitted: Aug 14, 2012 03:18 ET 
Proposal SEALED

 India  |  
Established in the year 2004, We have a decade of experience in area of Web/Desktop application development. We started with project that around...
10
  |  
 5.0   |  Private   |  2 Jobs
Bid ID: 32716306  |  Submitted: Aug 14, 2012 01:04 ET 
Proposal SEALED

 India  |  
TOP 5% WORDPRESS Tested Contractor on Elance. 3000+ HOURS. 150+ PROJECTS. 60+ SATISFIED CLIENTS, >30% REPEATED CLIENTS. WORDPRESS CUSTOM...
13
  |  
 5.0   |  Private   |  71 Jobs
Bid ID: 32715365  |  Submitted: Aug 14, 2012 00:12 ET 
Proposal SEALED

 United States
Winner
Build new database systems Backup and restore database system Set security on database, table, column... Maintainance :re-index, improve...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 32713980  |  Submitted: Aug 13, 2012 22:49 ET 
Delivery
Within 1 day
$25.00

 Egypt  |  
A computer scientist in the making, junior year; been working in web development field for over 5 years; got a very good experience with PHP,...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 32713785  |  Submitted: Aug 13, 2012 22:38 ET 
Proposal SEALED

 Malaysia  |  
My name is Sashi and I am very keen in open source technologies such as Linux(Fedora Core, Ubuntu, OpenSUSE), Java, Apache, MySQL, etc. I am...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 32713700  |  Submitted: Aug 13, 2012 22:32 ET 
Proposal SEALED

 India  |  
Believe in best quality and on time delivery
5
  |  
 4.9   |  Private   |  18 Jobs
Bid ID: 32713475  |  Submitted: Aug 13, 2012 22:17 ET 
Proposal SEALED

 China  |  
SilverFantasy Technology Consulting Co.,Ltd is one of the most QUALITY -and INNOVATION- Oriented software companies specializing in Online...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32713451  |  Submitted: Aug 13, 2012 22:16 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »