MySQL PHP Compare two tables and replace values

Question

I have a requirement to look at two tables and based on the column "id" where matching I need to replace the data in table "data" with what is in table "master data"

Here is table "data"

id      Required GPA
ZZZWD   2.2
EDFRD   4.0
DCFRE   
EDFRG   3.0

Here is table "master data"

id      Required GPA
ZZZWD   2.2
EDFRD   3.5
DCFRE   2.1
EDFRG   4.4

What is the most efficent way to do this?

Show us what you have tried first

Erick Kamamba
– Erick Kamamba

2016-03-06 20:02:51 +00:00
Commented Mar 6, 2016 at 20:02 — Erick Kamamba
– Erick Kamamba, Commented Mar 6, 2016 at 20:02

Alex Tartan · Accepted Answer · 2016-03-06 20:04:17Z

2

This should work out for you:

UPDATE `data`, `master_data`
SET `data`.required_GPA = `master_data`.required_GPA
WHERE `data`.id <> `master_data`.id
AND (`data`.required_GPA is null OR `data`.required_GPA = '')

answered Mar 6, 2016 at 20:04

Alex Tartan

6,84410 gold badges37 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL PHP Compare two tables and replace values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related