使用where with SQL在两列之间复制数据

Question

id | one  | two
1  | aa   |
2  | da   |
3  | sds  |
4  | as   |
5  | dfss |
6  | r    |
7  | fd   |

如何使用SQL将所有数据从“1”复制到“2”，其中长度为1的== 2？在此示例中应为：

id | one  | two
1  | aa   | aa
2  | da   | da
3  | sds  |
4  | as   | as
5  | dfss |
6  | r    |
7  | fd   | fd

Answer 1

我认为，这样的东西应该是可行的：

UPDATE table SET two = one WHERE LENGTH(one) = 2

Answer 2

UPDATE your_table SET two = one WHERE LENGTH(one) = 2