Terminé

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.

Compétences : MySQL, PHP, HTML, Design de site internet, Administration de Bases de données

en voir plus : 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

Concernant l'employeur :
( 2 commentaires ) Woodbridge, Canada

Nº du projet : #20869023

Décerné à:

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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% CAD en 1 jour
(0 Commentaires)
0.0

18 freelance font une offre moyenne de $24 pour ce travail

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(174 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(24 Commentaires)
6.0
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(30 Commentaires)
5.8
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(54 Commentaires)
5.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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(8 Commentaires)
4.7
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(14 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 5 jours
(20 Commentaires)
3.9
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(1 Évaluation)
3.6
sreenivas2903

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(8 Commentaires)
3.7
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(22 Commentaires)
4.0
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(5 Commentaires)
3.1
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(2 Commentaires)
2.8
ckrukp

@@@ This is my first time on this site but it isn't first time on my skills ... I already read your requirement in detail and as my checking, my latest project is very similar with your requirement. I have many experie Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(1 Évaluation)
1.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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(1 Évaluation)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(0 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(0 Commentaires)
0.0
harpreetwarney

Hi,I have 7 years of experience in PHP, Mysql.I am confident that I can handle this project. Waiting for positive response.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(0 Commentaires)
0.0