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](https://stackoverflow.com/questions/1262786/mysql-update-query-based-on-select-query) — Jaydeep Mor, Jul 03 '19 at 04: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, Jul 03 '19 at 05:07

score 1 · Accepted Answer · answered Jul 03 '19 at 04:21

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 03 '19 at 04:21

Nafis Islam

1,483
1
14
34

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

1 Answers1