Write some MySQL code
£20-250 GBP
Paid on delivery
Hi,
We require a freelancer to merge data from multiple tables in MySQL into a single table.
The data in the single table then needs to be synchronized with the multiple other tables when new data is added to those multiple tables (new data is added every 10-15 minutes).
Tasks:
1. Create an empty table
2. Fill table with n number of records
3. Write a function that sends NEW data in the multiple other tables in the same MySQL database to the table you just created.
4. Create a trigger, so that when the multiple other tables in the same MySQL database are updated with new data the function is called.
5. Ensure the new table has the same number of records after new data is added. In other words, this new table has a one in, one out policy.
Data and data types will be provided.
Please link to previous work in SQL.
THOSE WHO SUBMIT THE MYSQL FUNCTION OUTLINED IN TASK 3 WITH THEIR PROPOSAL WILL BE PREFERRED.
Project ID: #26945106
About the project
Awarded to:
Hi, I have read your job description carefully and i am very interested in this job. I am full stack web developer and i am very familiar with SQL. Please my last review on my profile. It is SQL job. I can start worki More
26 freelancers are bidding on average £151 for this job
Hello. I have already read your post and I'm ready to work now. Familiar SQL and have good experience in MySql. I value both of quality and speed in the work. Furthermore, I value the credit with employer. I am waitin More
Credit is capital. Hi! Pro MYSQL is here. I am a professional Web developer with a lot of experience and perfect knowledge for web development. Such as Python, WordPress, Laravel, HTML, CSS, JQ, PHP, React, Shopify More
Hello, I am professional software engineer having more than 7 years of experience in building software & websites using Microsoft technologies & tools. I specialized in Enterprise N-Tier applications using Microsoft T More
hello, i am new freelancer... select, join(inner, left and right, full join) where update delete orderby and groupby limit.....
Hello I want help you with Mysql I am php, js web developer, 8 years expierence I can start work right now
I can surely help you with PHP for your Website, as I have worked on a similar project before and will be able to complete it at the given time. Having High-level skills in PHP, Website Design, Graphic Design, WordPres More
@@@@ Hello! @@@@ My name is konstiatyn who is professional in SQL and MySQL. I am very interested in your project”Write some MySQL code”. I have gone through your description carefully and understand what u need. I h More
Hi, Hope you are fine. I'm a experienced Data Engineer/Scientist ready to do your work in an efficient way with strong analytical and logical reasoning skills. My day to day job is to write Python/SQL scripts for Data More
Hi, Manager! I'm a SQL expert for over 12+ years. Your job requries the SQL query handling. I understand all except 5. Cause the same number of records are related to your db. If your record arrange with the sequence More
Hello I have already done this type of work and I got review also for it. I can start work now,I can promise that I can do it. I am web developer having 4 year experience in PHP Laravel MySql jQuery JavaScript react More
A passionate and educated web developer, always following the best recommendations. Ready to offer your experience! Feel free to contact for an initial consultation.
I have experience with database, worked on several projects and assignments. Will make sure to meet all the requirements of your assignment so that you will get full marks from your professor.
Hello Sir I have long time experience handling with mysql, please hire me, I will complete your work on time and matching your needs. Best regards, Quy
Hello. After reading over your requirements this looks like a perfect fit for my skills sets. I have been a sql developer for 4 years . while i am certain there will be others who underbid me on this project, i can A More
Hi I am software developer and I am sure I can help you perfectly. I have rich experience with MySQL and I can do all you want by using SQL. And I always focus on the delivery and the best quality. Let's discuss with y More
Hi my name is Kelvin and am a proffesional in SQL and data entry and am willing to start working on ur project asap.