时间戳

首页 > 解决方案 > 如何使用两个不同的表基于单列更新多行

mysql - 如何使用两个不同的表基于单列更新多行

问题描述

我有两个表第一个表 js_resume 列是空的，但第二个表 js_resume 列有数据

当 js_resume 为空时，我想根据 js_email 进行比较，需要更新第二个表中的数据。

FIRST TABLE

+--------------------------------+-----------+
| js_email                       | js_resume |
+--------------------------------+-----------+
| panisam@hotmail.com            |           |
| rajchara-wee@hotmail.com       |           |
| jetnipit.s1992@gmail.com       |           |
| apitsada@hotmail.co.uk         |           |
| abcd@gmail.com                 |           |
| junebb@hotmail.com             |           |
| settasak.songthummin@gmail.com |           |
| james.oth@gmail.com            |           |
| balqisbinasli@gmail.com        |           |
| austinzmys@gmail.com           |           |
+--------------------------------+-----------+


Second table

+----------------------------+-------------------+
| js_email                   | js_resume         |
+----------------------------+-------------------+
| panisam@hotmail.com        | resume_59053.docx |
| rajchara-wee@hotmail.com   | resume_59051.docx |
| ragavansamy@gmail.com      | resume_59049.doc  |
| rajchara-wee@hotmail.com   | resume_59029.doc  |
| narasimha67@gmail.com      | resume_59047.doc  |
| abcd@gmail.com             | resume_59046.doc  |
| azilin.aw@gmail.com        | resume_59045.docx |
| lwy_51@yahoo.com           | resume_59044.docx |
| limnc@singnet.com.sg       | resume_59043.doc  |
| austinzmys@gmail.com       | resume_59042.docx |
+----------------------------+-------------------+

预期产出

+--------------------------------+----------------------------+
| js_email                       | js_resume                  |
+--------------------------------+----------------------------+
| panisam@hotmail.com            |  resume_59053.docx         |
| rajchara-wee@hotmail.com       |  resume_59051.docx         |
| jetnipit.s1992@gmail.com       |                            |
| apitsada@hotmail.co.uk         |                            |
| abcd@gmail.com                 |  resume_59046.doc          |
| junebb@hotmail.com             |                            |
| settasak.songthummin@gmail.com |                            |
| james.oth@gmail.com            |                            |
| balqisbinasli@gmail.com        |                            |
| austinzmys@gmail.com           | resume_59042.docx          |
+--------------------------------+----------------------------+

标签： mysql

解决方案

像这样的东西？

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

推荐阅读