Write some MySQL code

Concluído Postado há 3 anos Pago na entrega
Concluído Pago na entrega

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

ID do Projeto: #26945106

Sobre o projeto

26 propostas Projeto remoto Ativo em há 3 anos

Concedido a:

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 Mais

£80 GBP em 5 dias
(20 Comentários)
5.0

26 freelancers estão ofertando em média £151 nesse trabalho

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 Mais

£100 GBP in 2 dias
(6 Comentários)
4.9
letsstartcoding

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

£200 GBP in 2 dias
(18 Comentários)
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 Mais

£160 GBP in 7 dias
(9 Comentários)
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 Mais

£167 GBP in 7 dias
(2 Comentários)
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 dias
(5 Comentários)
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 dias
(3 Comentários)
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 Mais

£135 GBP in 7 dias
(2 Comentários)
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 Mais

£135 GBP in 7 dias
(1 Comentário)
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 Mais

£200 GBP in 3 dias
(5 Comentários)
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 Mais

£140 GBP in 2 dias
(1 Comentário)
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 Mais

£200 GBP in 7 dias
(1 Comentário)
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 Mais

£111 GBP in 3 dias
(1 Comentário)
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 em 1 dia
(2 Comentários)
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 dias
(0 Comentários)
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 dias
(0 Comentários)
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 Mais

£135 GBP in 3 dias
(0 Comentários)
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 Mais

£135 GBP in 7 dias
(0 Comentários)
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 Mais

£240 GBP in 7 dias
(0 Comentários)
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 dias
(0 Comentários)
0.0