Terminé

Need MySQL Expert

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.

Compétences : MySQL, Architecture Logicielle

en voir plus : expert mysql php flash adobe photoshop html, expert mysql security, mysql compare values, mysql need optimize, expert mysql indonesia, expert mysql linux, mysql modify values, mysql form values update, software write edid, software outsoucing payment system bid card, free software write company profile, expert mysql iis windows, mysql multiple values rows update, software developer average job fee hour, software write websites idea, software write book images, update mysql form values php, software write books, software write protection, free software write book, mysql multiple values cell, software write book, unlimited categories classified software php payment nested, convert mysql table values utf, write payment plug magento

Concernant l'employeur :
( 6 commentaires ) Hooksett, United States

Nº du projet : #12686766

Décerné à:

WebDev24Seven

hello! I have good set of skills in web development including mysql and 3 years of experience which makes me qualified for the task of solving this problem. You will have a quick response and solution in time. please m Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(1 Évaluation)
2.0

11 freelance font une offre moyenne de $110 pour ce travail

maxpl

Hi, I am a full stack web developer from Poland, I have 5+ years of experience in webdesign/development, WordPress, OperCart, E-commerce, obile Development, SEO and I have done number of projects. I can handle Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(9 Commentaires)
5.7
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(37 Commentaires)
5.0
WaheedGondal1

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 : Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(4 Commentaires)
4.7
angeledugo

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 pr Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(15 Commentaires)
4.7
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)
3.5
puschel

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(8 Commentaires)
3.6
zhenyi2015120

I'm a Good Web Expert. I have been developing php, javascript and mysql programs for 7 years. I have developed and managed many web sites. So I think I can do it so that you satisfy. I am looking forward to being h Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(3 Commentaires)
2.6
palak17

We are having an experience of 2 years and also provide surety of quality [login to view URL] are also having the team with innovative & creative ideas and good experienced in Google Analytic s and Internet Marketing and Web and G Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
1.8
dheerajkumar147

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
mediangel

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)
0.0