176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Need a mySQL trigger programmed
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

Job awarded.

Jul 13, 2013

Job awarded.

Jul 12, 2013

Job description changed. New Version|Previous Version

Jul 12, 2013
Close

Job Description

  |  Change History >>

Updated

Need an experience mySQL programmer to help build a trigger. Job Description: This is a pretty straight forward request. I would like to create a trigger that will update the sum of another column in a table. Table: ipbpfields_content Current Point Column: eco_points Lifetime Column: eco_lifetime When the eco_points column is updated with a positive count, i would like it to update the eco_lifetime column. If the eco_points column has an amount subtracted, I want it to ignore updating the eco_lifetime column. Basically I am just trying to add a column that will track the total point accumulation over time. No subtracting will ever be done.

Need an experience mySQL programmer to help build a trigger. Job Description: This is a pretty straight forward request. I would like to create a trigger that will update the sum of another column in a table. Table: ipbpfields_content Current Point Column: eco_points Lifetime Column: eco_lifetime When the eco_points column is updated with a positive count, i would like it to update the eco_lifetime column. If the eco_points column has an amount subtracted, I want it to ignore updating the eco_lifetime column. Basically I am just trying to add a column that will track the total point accumulation over time. No subtracting will ever be done. I am using mySQL 5.5

Jul 12, 2013

Close
  • Posted: Fri, Jul 12, 2013
  • 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
  • U.S. freelancers must have W9
Sign in to view client's details

Need an experience mySQL programmer to help build a trigger.

Job Description:
This is a pretty straight forward request. I would like to create a trigger that will update the sum of another column in a table.

Table: ipbpfields_content
Current Point Column: eco_points
Lifetime Column: eco_lifetime

When the eco_points column is updated with a positive count, i would like it to update the eco_lifetime column. If the eco_points column has an amount subtracted, I want it to ignore updating the eco_lifetime column.

Basically I am just trying to add a column that will track the total point accumulation over time. No subtracting will ever be done.

I am using mySQL 5.5

Sign in or Register to see more

Job ID: 44067112
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Sri Lanka  |  
Winner
I am a Software Engineer / Tech Lead who works in a reputed company for the last 6 years in .net technologies especially in Amazon Web Services,...
5
  |  
 5.0   |  Private   |  16 Jobs
Bid ID: 44068911  |  Submitted: Jul 12, 2013 20:06 ET 
Delivery
Within 1 day
$43.84

 Romania  |  
Currently MySQL DBA at Netbridge Development, Romania. I have CMDEV (Certified MySQL Developer) and CMDBA (Certified MySQL Database Administrator)...
4
  |  
 5.0   |  Private   |  2 Jobs
Bid ID: 44068890  |  Submitted: Jul 12, 2013 20:05 ET 
Proposal SEALED

 India  |  
PS SoftWeb is a leading IT company offering services in Information technology domain. We are well versed with the expert team of developers having...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 44068083  |  Submitted: Jul 12, 2013 19:23 ET 
Proposal SEALED

Alejandro Luis Gonzalez Tokman      
Alejandro Luis Gonzalez Tokman's identity has been verified.  Learn More
 Mexico  |  
Winner
I'm a professional developer and I'm open to learn everything I'd need to finish my projects. My goal is to finish every job in time and with the...
5
  |  
 5.0   |  Private   |  1 Jobs
Bid ID: 44067598  |  Submitted: Jul 12, 2013 18:58 ET 
Delivery
Within 1 day
$20.00

iTech Highway      
One or more team members at  are verified.  Learn More
 Ukraine  |  
INVITED
iTech Highway is a software company located in Ukraine made up of creative and highly skilled developers. We produce desktop and mobile...
9
  |  
 5.0   |  Private   |  8 Jobs
Bid ID: 44067358  |  Submitted: Jul 12, 2013 18:47 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 »