Completed

Write some MySQL code

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.

Skills: SQL, MySQL

See more: captcha code entry work, rollover code wont work website, order entry system java mysql code, multi search mysql code dreamweaver, write html code images, php mysql code bid, php5 mysql code, short code britain work united states, write html code image, create appointment using php mysql code, sample mysql code payroll program, java jmf wecam java sample code 100 work, connect board java write game code, write integration code, write twitter code php mysql, looking for someone to write php code mysql, the setup routines for the mysql odbc 5.3 ansi driver error code 126, there are two types of people....those who do the work, write code to work with excel in vba forms and then create employee record and update it

About the Employer:
( 17 reviews ) London, Germany

Project ID: #26945106

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
(16 Reviews)
4.9

34 freelancers are bidding on average £146 for this job

WebXcellance

Hello there, We will work with you, Having 5 year experience in MySQL website design and developments. Please provide more detail about the project, also see our recent work. [login to view URL] http More

£166 GBP in 3 days
(16 Reviews)
5.1
vladrassolov82

Hi,Nice to meet you I have just read your requirement and understood it perfectly I am expert in Mysql and PHP,I have excellent sql queries in mysql and sql. So I am really interested in your project and I can help you More

£170 GBP in 1 day
(10 Reviews)
4.3
bodya24

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.

£135 GBP in 2 days
(7 Reviews)
4.3
(7 Reviews)
4.1
TEKSCENT

better to create a [login to view URL] will be like this create procedure abc begin insert into newtable (select column1,column2 from table 1 join table 2 where 1=1); end like this. and then we can create trigger to call t More

£244 GBP in 1 day
(13 Reviews)
4.1
letsstartcoding

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

£200 GBP in 2 days
(11 Reviews)
4.2
sanjeev2727

Hello, I am expert web Developer and having 6+ years experience. I can create mysql function triggers as per your requirement. Let me know sir. Thankyou. My work:- [login to view URL] [login to view URL] echeck. More

£100 GBP in 3 days
(6 Reviews)
3.8
wanqing525

****Database and database converting developer**** Hi, there. I am a creative and professional Database and database convert application developer having more than 5+ years of professional experience as a senior develo More

£135 GBP in 3 days
(8 Reviews)
3.4
piskun699

Hello ✋✋✋! I am very interested in your proposal and can complete this project as you need. I am a professional in MySQL, so have rich experience. With many works for previous jobs, I am able to proof confidently my s More

£150 GBP in 7 days
(2 Reviews)
2.7
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)
2.8
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
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.4
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
(4 Reviews)
3.0
adibonchis99

**** Your project is a piece of cake for me ***** I have checked your job descriptions carefully . I have enough experiences in Mysql and Database Management. So I think I am a great fit for your project. Please contac More

£50 GBP in 3 days
(1 Review)
1.8
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
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
(2 Reviews)
2.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
(1 Review)
1.1
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.1
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