Looking for MySQL expert to create Trigger

$30-250 USD

Chiuso

Pubblicato

più di 4 anni fa

$30-250 USD

Pagato al completamento

Looking for MySQL expert to create Trigger, which will execute after each select query IF the exactly column names (as a pattern) EXIST in the select query. Example: We have a table with columns: id, country, state, city, address The trigger MUST be executed only IF the select query contains "id" and "state" and not other column names, here is a short example: Trigger executed: SELECT id, state FROM our_table; SELECT id, state FROM our_table WHERE country LIKE 'some_country' AND address LIKE 'any_address'; Trigger NOT executed: SELECT id, country, city, address FROM our_table WHERE country LIKE 'some_country'; SELECT id, state, city FROM our_table WHERE city LIKE 'some_city'; SELECT state FROM our_table WHERE id < 5; Quick question for MAX $10!!!! Please bid if you can provide the query shortly and you are agreed with the $10 rewards!!! Thank you

MySQL

PHP

Software Architecture

JavaScript

SQL

Rif. progetto: 23553832

Info sul progetto

12 proposte

Progetto a distanza

Attivo 4 anni fa

Hai voglia di guadagnare un po'?

Indirizzo Email

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze

Fatti pagare per il lavoro svolto

Delinea la tua proposta

La registrazione e le offerte sui lavori sono gratuite

12 freelance hanno fatto un'offerta media di $85 USD

@kchoudhary95

I am a full-stack developer with a career in the IT industry of over 4 years. I have rich experiences with many people and they always get the best result. It's a piece of cake for me! You'll not waste your GOLD TIME. I readed through the job details extremely carefully and It's very easy for me. Can we have quick chat right now so that we can discuss the project briefly? Please give me a chance to work as your on-going partner! I will do everything in my power to assist you Regards.

$55 USD in 2 giorni

5,0

(88 valutazioni)

5,8

@hassanafzal6

Hello. I am a Web developer with experience in Mysql. I can create trigger for you in short time. Hit me up.

$55 USD in 2 giorni

5,0

(20 valutazioni)

5,3

@techobrie

I have gone through your Job post and I can understand your job requirement thoroughly. I have a total of 15 years of experience in Web Designing and Development, AI, Mobile Development and various exepertise in Graphic Development, Digital marketing too. and had completed a number of projects with some great graphics and User Interface so far. I have all the required skills and experience you need for the above Job. I have strong command over: * WordPress, PHP, Wordpress themeing, Plugin Development * Android and IOS all kind of mobile apps development *Responsive theme Design * HTML5, CSS3 , Jquery, Bootsrtap, Git, * Widget Development * Other CMS: Magento, Joomla, Expression Engine, Drupal etc. * I’m honest & trustworthy, dependable & fast learner. * I’ve over 7 years experience in Wordpress Website designing/development. * I am available 40 hours a week for your job. You can be assured of a quality communication and the quality of the work provided from my end. I’m looking forward to hearing from you soon. Thank you for considering my cover letter.

$90 USD in 7 giorni

3,7

(56 valutazioni)

5,6

@ayyar1

Sir, I am a MySQL expert databases and I can write the queries and the trigger you need. Please initiate the chat for detail discussion of the project. I look forward to working with you. Thanks for reading. Best Regards.

$30 USD in 3 giorni

5,0

(13 valutazioni)

4,0

@sankargan88

I can help you to complete your task within 2 days. as i have an experience of 10+ overall experience and 4+ years in MySQL Database. Also i am expert in writing triggers. Initiate the chat and share the details.

$111 USD in 2 giorni

5,0

(1 valutazione)

2,3

@gorserg

Hi. You can't create trigger on SELECT command (only INSERT, UPDATE or DELETE). This can be done using you code (ORM) or some middleware between database and data consumer (client, API, ..). Can you describe your task (and environment) with more details.

$30 USD in 1 giorno

5,0

(2 valutazioni)

2,0

@rafaqatali12780

I agree $10 reward. I have read your requirement and I can do this task please let me know if this is still available so we can discuss more

$30 USD in 7 giorni

0,0

(0 valutazioni)

0,0

@JonathanBuntuguh

Hello, I'm Jonathan. I have had over 4 years of experience building triggers and stored procedures for normalised and denormalised databases. From your example, I will first check if the new id and state are not null before doing the select into a variable. And yes, i can provide a query as soon as possible. Thanks

$40 USD in 2 giorni