Write some MySQL code

Completed Posted 3 years ago Paid on delivery
Completed 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.

SQL MySQL

Project ID: #26945106

About the project

26 proposals Remote project Active 3 years ago

Awarded to:

lordzephirot

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

£80 GBP in 5 days
(20 Reviews)
5.0

26 freelancers are bidding on average £151 for this job

oxanarvayva

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

£100 GBP in 2 days
(6 Reviews)
4.9
letsstartcoding

yes got your all points ans i will take 2 to3 days to finsh this job

£200 GBP in 2 days
(18 Reviews)
4.7
rkurilenko007

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

£160 GBP in 7 days
(9 Reviews)
4.4
fakhruddinb

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

£167 GBP in 7 days
(2 Reviews)
4.3
nemanja1029

hello, i am new freelancer... select, join(inner, left and right, full join) where update delete orderby and groupby limit.....

£135 GBP in 7 days
(5 Reviews)
3.3
fff2017aleksandr

Hello I want help you with Mysql I am php, js web developer, 8 years expierence I can start work right now

£135 GBP in 7 days
(3 Reviews)
2.7
MukhammedAli

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

£135 GBP in 7 days
(2 Reviews)
3.4
PKonstiantyn

@@@@ 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

£135 GBP in 7 days
(1 Review)
2.6
saqibsohail1

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

£200 GBP in 3 days
(5 Reviews)
1.8
johnjadercuesta

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

£140 GBP in 2 days
(1 Review)
2.0
kkr13590

Hi, I have 7 plus year of experience in developing web and desktop application and also competent knowledge in database query and plsql writing. hop for positive response and further discussion. Regards, Kamlesh Kum More

£200 GBP in 7 days
(1 Review)
1.0
amtech1410

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

£111 GBP in 3 days
(1 Review)
0.8
arturaghajanyan8

A passionate and educated web developer, always following the best recommendations. Ready to offer your experience! Feel free to contact for an initial consultation.

£50 GBP in 1 day
(2 Reviews)
1.0
srishti25sagar

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.

£222 GBP in 3 days
(0 Reviews)
0.0
vinadeveloper

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

£70 GBP in 3 days
(0 Reviews)
0.0
anaabdoo11

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

£135 GBP in 3 days
(0 Reviews)
0.0
andreyignatenko1

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

£135 GBP in 7 days
(0 Reviews)
0.0
Hrtechllc

Hello there, We read your job description and surely, we can help you with MySQL We are a company working for the last 5 years, but we are new to freelancer.com, so you might find our profile new. Our reviews do not More

£240 GBP in 7 days
(0 Reviews)
0.0
kevokims

Hi my name is Kelvin and am a proffesional in SQL and data entry and am willing to start working on ur project asap.

£135 GBP in 7 days
(0 Reviews)
0.0