How to update multiple rows based on single column using two different tables

Question

I Have a two tables first table js_resume column is empty but second table js_resume column have a data

I want to compare based on js_email when js_resume is empty need to update data from second table .

FIRST TABLE

+--------------------------------+-----------+
| js_email                       | js_resume |
+--------------------------------+-----------+
| [email protected]            |           |
| [email protected]       |           |
| [email protected]       |           |
| [email protected]         |           |
| [email protected]                 |           |
| [email protected]             |           |
| [email protected] |           |
| [email protected]            |           |
| [email protected]        |           |
| [email protected]           |           |
+--------------------------------+-----------+


Second table

+----------------------------+-------------------+
| js_email                   | js_resume         |
+----------------------------+-------------------+
| [email protected]        | resume_59053.docx |
| [email protected]   | resume_59051.docx |
| [email protected]      | resume_59049.doc  |
| [email protected]   | resume_59029.doc  |
| [email protected]      | resume_59047.doc  |
| [email protected]             | resume_59046.doc  |
| [email protected]        | resume_59045.docx |
| [email protected]           | resume_59044.docx |
| [email protected]       | resume_59043.doc  |
| [email protected]       | resume_59042.docx |
+----------------------------+-------------------+

Expected Output

+--------------------------------+----------------------------+
| js_email                       | js_resume                  |
+--------------------------------+----------------------------+
| [email protected]            |  resume_59053.docx         |
| [email protected]       |  resume_59051.docx         |
| [email protected]       |                            |
| [email protected]         |                            |
| [email protected]                 |  resume_59046.doc          |
| [email protected]             |                            |
| [email protected] |                            |
| [email protected]            |                            |
| [email protected]        |                            |
| [email protected]           | resume_59042.docx          |
+--------------------------------+----------------------------+

Possible duplicate of MySQL - UPDATE query based on SELECT Query — Jaydeep Mor
– Jaydeep Mor, Commented Jul 3, 2019 at 4:23
i want to to update a first table value based on second table ,,,better you see what i want in above example,,am not not using select query — Arumugam Rajamani
– Arumugam Rajamani, Commented Jul 3, 2019 at 5:07

Nafis Islam · Accepted Answer · 2019-07-03 04:21:16Z

1

Something like this?

UPDATE FIRSTTABLE a
    JOIN Secondtable b ON a.js_email = b.js_email
SET a.js_resume = b.js_resume

answered Jul 3, 2019 at 4:21

Nafis Islam

1,5172 gold badges16 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

How to update multiple rows based on single column using two different tables

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related