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:
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.
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
18 freelance font une offre moyenne de $24 pour ce travail
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.
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
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
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
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
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
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
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
Hi. Iam expertise in sql queries and triggers please let me know if u are interested ping me for more information
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
~~~~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
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
@@@ 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
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
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
Hi,I have 7 years of experience in PHP, Mysql.I am confident that I can handle this project. Waiting for positive response.