Færdiggjort

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

Evner: MySQL

Se mere: 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

Om arbejdsgiveren:
( 2 bedømmelser ) Farmington Hills, United States

Projekt ID: #22400625

Tildelt til:

sauden23

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

$40 USD på 1 dag
(3 bedømmelser)
2.2

21 freelancere byder i gennemsnit $121 på dette job

superwanchiu

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 Flere

$155 USD in 3 dage
(40 bedømmelser)
5.7
letshappy

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 dage
(19 bedømmelser)
5.5
dreammate0621

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: https://www.freelancer.com/u/dreammate0621?w=f) I have much experience working on mys Flere

$50 USD på 1 dag
(7 bedømmelser)
4.4
mobileexpert1235

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, Flere

$140 USD in 7 dage
(6 bedømmelser)
4.6
Albertbestcoder

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

$140 USD in 7 dage
(3 bedømmelser)
4.1
lesteraguilar

*****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 Flere

$120 USD in 7 dage
(5 bedømmelser)
4.1
Jinzin

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 Flere

$140 USD in 7 dage
(6 bedømmelser)
3.8
romancoder204

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 Flere

$140 USD in 2 dage
(6 bedømmelser)
3.6
BestPrince1120

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 Flere

$50 USD på 1 dag
(11 bedømmelser)
3.7
Panda393

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 dage
(1 bedømmelse)
3.3
KonstanBer

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 Flere

$150 USD på 1 dag
(1 bedømmelse)
2.6
StormLion227

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 freelancer.com and I do not bid on projects whic Flere

$140 USD på 1 dag
(3 bedømmelser)
3.4
swedenkoroman

❤️ Hello,How are you?❤️ I read carefully your posting. I am very happy to get this opportunity to bid for your project. I am a web developer with full skill for 6+years development. I have developed lots of website usi Flere

$140 USD in 7 dage
(1 bedømmelse)
2.0
uxiaojuan2019

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 Flere

$140 USD in 7 dage
(1 bedømmelse)
1.6
Sidhucs

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 Flere

$140 USD in 7 dage
(0 bedømmelser)
0.0
SeniorTop325

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 Flere

$50 USD in 2 dage
(0 bedømmelser)
0.0
alexanderanisimo

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 Flere

$140 USD in 7 dage
(0 bedømmelser)
0.0
GogolevMax1

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

$140 USD in 7 dage
(0 bedømmelser)
0.0
growthnixdev

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 Flere

$140 USD in 7 dage
(0 bedømmelser)
0.0
kovacsferi

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 Flere

$100 USD på 1 dag
(0 bedømmelser)
0.0