Create a trigger in MYSQL database to relate 2 tables.

I have 2 table in a MYSQL database

Table #1 is called patient_data (The parent table)

Table #2 is called patient visits (The child table)

The 2 tables have columns that are common to both

The columns that are common to both are

1) pid --> patient id

2)fname --> firstname

3)lname --> lastname

4) DOB --> Date of birth

I want to use a mysql trigger so that every time I add or edit a record in the parent table, the same edit is reflected on the child table

Whoever gets this project must have a web accessible server and some dummy data in a Mysql database so I can test the functionality before payment

Skills: MySQL

See more: create pdf mysql database, create mysql database iis, create reports mysql database, delete trigger mysql, mysql trigger if, mysql trigger after delete, create trigger mysql, mysql trigger variables, mysql trigger before delete, mysql trigger on update specific column, mysql trigger after insert or update, mysql create email collection database, create mysql database phpmyadmin, phpfilenavigator create mysql database, create documentation mysql database, create mysql database form, create web forms mysql database, create pdf report mysql database, create web interface view mysql database, create manage connect mysql database

About the Employer:
( 4 reviews ) Farmington Hills, United States

Project ID: #22400625

Awarded to:


Hello , I am professional database developer and I am expert in sql. Please message me for further discussion. Thank You.

$40 USD in 1 day
(3 Reviews)

20 freelancers are bidding on average $120 for this job


Hello , How are you? I just saw your project description carefully. I am very interested in your project. I have rich experience in PHP and MySQL. I am ready to start your project immediately. I am sure I can sa More

$155 USD in 3 days
(40 Reviews)

hey, i read the project and i got it carefully and i am ready to start work on it have more then 9 years working experience in mysql

$137 USD in 3 days
(19 Reviews)

Hi there? I have reviewed your description carefully, understood fully your requirements. You want a 100% job completion with high-quality? As you see, I am an advanced web developer who have completed lots of medium, More

$140 USD in 7 days
(6 Reviews)

Dear Client! I am very happy to see your project detail. I think it is just my project. :) As you can see in my profile, (my review: I have much experience working on mys More

$50 USD in 1 day
(8 Reviews)

Hello, Dear! i am a full DATABASE developer with over 5 years on ****In SPECIAL Very familar with MySQL,MSSQL,SQLite,MongoDB,ACCESS...***** I am ready for your project now. I can do it and start right More

$140 USD in 7 days
(3 Reviews)

*****Dear Sir***** Welcome to your job :) I have read your description carefully. Aa a senior developer,I can handle it with full confidence and have already done this type of projects. Please give me an opportunity More

$120 USD in 7 days
(5 Reviews)

Greetings!! I have read your requirements carefully and i found my self fit in order to complete this project I Have vast experience in development and i have also made same kind of web application on same platform s More

$50 USD in 1 day
(17 Reviews)

Hello Dear warm Greeting :) Nice to meet you. I am Xianyi from china I am interesting in your project. I am wordpress expert and working for many years in this fields. I can build your project perfectly with my experie More

$140 USD in 7 days
(6 Reviews)

How are you? I just have read your requirement very carefully. While reading your job description, I understood your main goal. As I am strong at this kind of project, I am pretty sure that I can provide you high qual More

$140 USD in 2 days
(8 Reviews)

Hello I am senior developer with rich experience in mysql. I read your project description carefully. If you choose me, I'll provide satisfied result you want Thank you

$140 USD in 7 days
(1 Review)

Good day! I am very interested to your project and ready to start right now. I have read your project requirement carefully. I have many experience in MySQL and PHP. I can meet your requirement Give me one chance to wo More

$150 USD in 1 day
(3 Reviews)

Hi. I have read your job description carefully and fully understood what you want. As a full stack developer I have 5 years of experience in back-end development. Especially, Mysql is my top skill. I have ever buil More

$50 USD in 2 days
(1 Review)

Dear Sir! I’d like to describe myself as someone who is versatile and determined and someone who loves learning. I am creative, open-minded and easy-going and I enjoy working with others. And I tried to use all these q More

$100 USD in 1 day
(1 Review)

I have deep and proven experience in T-SQL development and debugging of queries with huge complexity. My total MSSQL Experience is 10+ years. Five of them was within USA company as Senior SQL/BI Developer. My everyday More

$140 USD in 7 days
(1 Review)

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. A MySQL Expert on and I do not bid on projects whic More

$140 USD in 1 day
(3 Reviews)

Check [login to view URL] and [login to view URL] develop spring boot+hibernate+ payment gateway integration develop and maintenance by siddhu consultancy services private limited. First showing me the complete information More

$140 USD in 7 days
(0 Reviews)

Hello. I saw your description and db table carefully. I am mysql expert. I have full experiences more than 5 years. I am ready for you now. If I have a chance to help you, I will work honest and ASAP I think you wil More

$140 USD in 7 days
(0 Reviews)

Hi I can do it immediately Thanks. :) ............................................................................................

$140 USD in 7 days
(0 Reviews)

Hi, I was reading this project and I'm confident I can help you with this. I can provide you some samples and some of my references of work if you are interested. Please send me a message as I'd like to discuss more More

$140 USD in 7 days
(0 Reviews)