Find Jobs
Hire Freelancers

MySQL Query with Trigger

$10-30 CAD

Imekamilika
Imechapishwa over 4 years ago

$10-30 CAD

Kulipwa wakati wa kufikishwa
I have a website hosted with service provider "Hostpapa" . This website has a MySql database/ Once contract awarded, we will schedule a time for you to login to my computer with Teamviewer, and access the database to code this query/trigger. We need a new table created, that overwrites with current data, every time a new entry is made in another table. Table 1 is already existing with data, called "form-job_hazard_analysis". When a new entry is added to this table, a query will be triggered as below. Table 2 will be overwriten, and keep the most current results only of the query, after a new entry is added to the above table. the table is called "form-query_jha" A query is run with the following parameters: SELECT `form-job_hazard_analysis`.* FROM `form-job_hazard_analysis` WHERE DATE_SUB(CURDATE(),INTERVAL 3 DAY) <= `form-job_hazard_analysis`.date_of_jha; The results of this query will overwrite the data in a table called "form-query_jha" All columns of the original table query will be overwritten in the result table.
Kitambulisho cha mradi: 20869023

Kuhusu mradi

12 mapendekezo
Mradi wa mbali
Inatumika 5 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
pay if you like it tables must have identical structures. if not specify values via brackets CREATE TRIGGER `reset_table` AFTER INSERT ON `form-job_hazard_analysis` FOR EACH ROW begin delete from `form-query_jha` where 1=1; insert into `form-query_jha` select * FROM `form-job_hazard_analysis` WHERE DATE_SUB(CURDATE(),INTERVAL 3 DAY) <= `form-job_hazard_analysis`.date_of_jha; end
$10 CAD ndani ya siku 1
5.0 (1 hakiki)
0.0
0.0
12 wafanyakazi huru wana zabuni kwa wastani $24 CAD kwa kazi hii
Picha ya Mtumiaji
Sir, I have gone through your project description and am looking to provide my service for database triggers writing. For more than 7 years I’ve worked in this field.
$50 CAD ndani ya siku 2
4.8 (203 hakiki)
6.9
6.9
Picha ya Mtumiaji
Dear Client! I am very happy to see your project detail. I think it is just my project. :) I already read your requirement and understood fully. As you can see in my profile, (my review: https://www.freelancer.com/u/kyleevert?w=f) I have much experience with your job. I think you can contact me and discuss more your project. I will provide good service and high quality. Regards!
$20 CAD ndani ya siku 7
5.0 (27 hakiki)
6.3
6.3
Picha ya Mtumiaji
HI, sir. ****************** I'm a senior web&app developer with over 8 years of experience and very strong in handling database MySql. If you want to work with me, I am sure I can deliver you a wonderful result as you want. Please send me a message so that we can discuss more. ****************** Best regards.
$20 CAD ndani ya siku 7
4.9 (54 hakiki)
5.8
5.8
Picha ya Mtumiaji
Hello, I'd like to work for you. I've already written several triggers and events for mysql and your problem is quite easy to solve if you know how. So I think I'm a good choice for your project and I hope to year from you. Best regards Emanuel
$20 CAD ndani ya siku 1
5.0 (8 hakiki)
4.7
4.7
Picha ya Mtumiaji
HI, im an senior DBA and i can help you with your requirement, its a simple task, i can finish on a few hours. regards
$30 CAD ndani ya siku 1
5.0 (2 hakiki)
3.6
3.6
Picha ya Mtumiaji
Hi. Iam expertise in sql queries and triggers please let me know if u are interested ping me for more information
$40 CAD ndani ya siku 1
4.7 (8 hakiki)
3.7
3.7
Picha ya Mtumiaji
Hi,I have 7 years of experience in PHP, Mysql.I am confident that I can handle this project. Waiting for positive response.
$30 CAD ndani ya siku 2
5.0 (1 hakiki)
1.0
1.0
Picha ya Mtumiaji
Deer Employer! I have read your details carefully and it seems like I'm the best fit for you. I am a mobile app developer with 5+years experiences . I have rich experiences in Android, iPhone, C++, Matlab, Java, Photoshop etc. My goal is to create products that clients and users will love to use. I am a full-time freelancer, so feel free to contact me at any time. Looking forward to working with You. Let's build the great relationship and go forward the success of your project. Thanks!
$10 CAD ndani ya siku 1
5.0 (1 hakiki)
0.4
0.4
Picha ya Mtumiaji
Hi, I have more than 3 years of rich experience in latest technologies like : Laravel, Shopify, Magneto, WordPress . I am also very much skilled in core PHP, Web Scraping, HTML, CSS and JavaScript + Jquery. Moreover, I have good experience in handling client for whom I have worked remotely. Regards, Usman
$20 CAD ndani ya siku 7
0.0 (0 hakiki)
1.1
1.1
Picha ya Mtumiaji
Hello Team, We an do project as per your requirements, I am expert in PHP , Mysql DB., Lets connect, I can solve in few mins
$20 CAD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya CANADA
Woodbridge, Canada
5.0
3
Njia ya malipo imethibitishwa
Mwanachama tangu Nov 17, 2018

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.