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).
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.
34 freelancers are bidding on average £146 for this job
Hi, I can make some MySQL query to meta data from multiple tables to single table. I am senior web expert and have plenty experience with MySQL. I can start work right now. Best regards.