Find Jobs
Hire Freelancers

Need MySQL Expert

$30-250 USD

In Progress
Posted over 7 years ago

$30-250 USD

Paid on delivery
Payment only, for the solution, not any incremental work to achieve the solution. Expert must have their own gear and software platform to perform the job, without access to Fahmah Jackson Resources. Here is the problem. I need to be able to provide atomic support for a thread safe way to update mysql database table that already exists. Here is my logical representation of the code execution...Make this able to work in a query box on phpmyadmin (GoDaddy). Here is my logical attempt which gets summarily rejected by the mySql engine for syntax errors. START TRANSACTION; IF (SELECT 1 = 1 FROM `tims_test_table` WHERE `item_id` = 99 AND `field_id` = 19 ) THEN BEGIN UPDATE `tims_test_table` SET `meta_value` = 'UPDATE' WHERE `item_id` = 99 AND `field_id` = 19; END; ELSE BEGIN INSERT INTO `tims_test_table` (item_id,field_id,meta_value) VALUES(99,19,'INSERT'); END; END IF; COMMIT; The result of the execution on the first run should put 'UPDATE' into the table. If run a second time, then 'INSERT' should be what I see in the 'meta_value' column in the table where item_id = 99 and field_id = 19. The table has three columns (item_id, field_id, meta_value). I am paying for a solution not an hourly rate. I cannot change the database in any way to suit alternative coding techinques or locking engines. I will take the solution and run it. If there are any error messages, I will forward them to the expert who accepts this bounty and the solution should be worked to it's conclusion. There is a 48 hour time limit to this project. The problem is that I have two threads of code, updating the database and causing duplicate entries. I cannot use primary keys or other techniques to ensure atomic execution. Setting global locks and causing other threads to wait is not permissable either. The solution relies on mysql running a complex query/update/insert, atomically.
Project ID: 12686766

About the project

9 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
9 freelancers are bidding on average $115 USD for this job
User Avatar
Dear Sir, Hope you are doing well, I have read your job description, I am willing to work with you. I have already done similar job and win 5 star rating with wonderful review. Key Responsibilities are : - I ll complete all of your requirements - I ll do more tweaks for you as well Sir i ensure you that i am best suit for this post. Please open chat with me so we can discuss more in details Looking forward to hear from you. Best Regards, Waheed Gondal
$194 USD in 5 days
5.0 (5 reviews)
5.0
5.0
User Avatar
Hi, I'm Ing of systems With over 10 years of experience developing large-scale applications and providing web technology solutions for freelancers , small, medium and large businesses. experience working with the private sector and public my skills 1) HTML5 + CSS3 2) PHP POO laravel, Zend 3) Javascript Boostrap, Jquery, Angular 4) Database Mysql, Oracle, Postgresql 5) GIT, SVN I'm Available for this job. Thanks good day
$100 USD in 3 days
4.6 (20 reviews)
4.9
4.9
User Avatar
I have a solution for this, but it doesn't work with PHPMYADMIN, because phpMyAdmin has an intergrated parses that doesn't work with this solition
$35 USD in 1 day
5.0 (8 reviews)
3.6
3.6
User Avatar
A proposal has not yet been provided
$222 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! I am an expert in MySql and I can write the query using your logic and requirements. I am ready to work under the terms you have mentioned and will deliver shortly after being awarded.
$30 USD in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Hooksett, United States
5.0
6
Member since Apr 15, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.