Suoritettu

MySQL Query with Trigger

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.

Taidot: MySQL, PHP, HTML, verkkosivujen suunnittelu, Tietokannan hallinto

Näytä lisää: edit csv mysql query, asp mysql query, 2013 lost connection mysql query, mysql trigger after delete, mysql trigger on update specific column, types of triggers in mysql, mysql trigger before insert, delete trigger mysql, mysql trigger variables, mysql trigger before delete, mysql trigger after insert or update, mysql query report, php mysql query table, mysql query record bash, mysql query csv file, write mysql query, optimize mysql query software, mysql query php table css, php mysql query format table, mysql query search

Tietoa työnantajasta:
( 3 arvostelua ) Woodbridge, Canada

Projektin tunnus: #20869023

Myönnetty käyttäjälle:

NeonWired

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` wh Lisää

$10 CAD 1 päivässä
(1 arvostelu)
0.0

17 freelanceria on tarjonnut keskimäärin 23$ tähän työhön

ARKSolution2015

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 2 päivässä
(176 arvostelua)
6.8
kyleevert

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/ky Lisää

$20 CAD 7 päivässä
(25 arvostelua)
6.2
nisharapath

Hello. I read your project fully and it is possible for me. As you can see my profile, I have rich experiences in web,mysql. If you hire me, I will do my best and you will see successfully result. Please contact me. K Lisää

$20 CAD 1 päivässä
(34 arvostelua)
5.9
shingjin

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 yo Lisää

$20 CAD 7 päivässä
(54 arvostelua)
5.8
romansokolv708

Dear client! I read your project details carefully. I am very interested in your project because I have vast experieces like that before. Frankly speaking, your task is piece of cake for me. As a senior full stack de Lisää

$20 CAD 1 päivässä
(17 arvostelua)
4.8
UEmanuel

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 f Lisää

$20 CAD 1 päivässä
(8 arvostelua)
4.7
jain602

Hi Hope you are doing well. Going through your project description we understand that you are looking for an experienced team in website designing to work on your assignment. We are pleased to inform you that we ha Lisää

$15 CAD 5 päivässä
(27 arvostelua)
4.4
seniorcoder024

Hi. Sir I would be very glad to meet you. I read your description carefully. I can bring you perfect result as you want. I am an experienced web developer and designer with the depth knowledge related to PHP, Bootstrap Lisää

$20 CAD 2 päivässä
(11 arvostelua)
4.2
fivestarOne

Hi! I have developed web application for 4+ years. My results will be your favourite one. I made many web applications using mysql, mongodb. If you interest in my skills, hire me. Then you will see good results. Thank Lisää

$20 CAD 7 päivässä
(24 arvostelua)
4.3
creaspa

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 1 päivässä
(2 arvostelua)
3.6
sreenivas2903

Hi. Iam expertise in sql queries and triggers please let me know if u are interested ping me for more information

$40 CAD 1 päivässä
(8 arvostelua)
3.7
sharpman1013

~~~~Dear Client.~~~~~ Thank you for your posting job. I have checked your job description carefully and I'm very confident I can complete this project perfectly without any fault. I have already developed many Web site Lisää

$30 CAD 1 päivässä
(6 arvostelua)
3.2
harpreetwarney

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 2 päivässä
(1 arvostelu)
0.9
WhitebirdH

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, Photo Lisää

$10 CAD 1 päivässä
(1 arvostelu)
0.4
usmanirfanuaf

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 Lisää

$20 CAD 7 päivässä
(0 arvostelua)
0.0
Antomuthu09

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 1 päivässä
(0 arvostelua)
0.0