如何从备份更新数据表的单列 [英] How to update a single column of a table of data from a backup

问题描述

成员表列中的所有数据已被删除，但我在几周前对该表进行了备份。

All the data in a column of a table of members have been erased, but I made a backup of the table a few weeks ago.

因此，我需要

问题是我不知道我该怎么办。

The problem is that I do not know how I should proceed to do so.

您遇到这个问题，可以向我解释。

Have you been confronted by this problem and can you explain it to me

推荐答案

1. 将表格备份还原为临时表格。


2. 使用 UPDATE语句，选择更新您的成员表

1. Restore the backup of your table as a temporary table.
2. Use a UPDATE statement with select to update your members table

这些步骤是你在困难吗？

Which one of these steps are you having difficulty with?

这里是我如何写一个SQL从成员_temp表更新我的成员表

Here is how I would write the SQL to update my members table from a "members_temp" table

 UPDATE members SET name=(select name from members_temp where members.id = members_temp.id)

这篇关于如何从备份更新数据表的单列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！