单元格字符串重复

ecfdbz9o 于 2021-07-29 发布在 Java

关注(0)|答案(1)|浏览(275)

我有一个联系人数据库表。

ID = 1    
Full_Name = Joe Bloggs    
Primary Email = SomeEmail@Test.com    
Secondary Email = Null

是否可以使用sql查询将每个联系人的主要电子邮件复制到次要电子邮件中，如下所示：

ID = 1    
Full_Name = Joe Bloggs    
Primary_Email = SomeEmail@Test.com    
Secondary_Email = SomeEmail@Test.com    

ID = 2    
Full_Name = Ruth Jones    
Primary_Email = TestEMail@Test.com    
Secondary_Email = TestEMail@Test.com

提前谢谢！

sql Database

来源：https://stackoverflow.com/questions/62700554/duplicate-cell-string

1条答案

按热度按时间

cygmwpex1#

您只需设置：

UPDATE your_table SET Secondary_Email = Primary_Email

赞(0）回复(0）举报 2021-07-29

我来回答

单元格字符串重复

1条答案

相关问题

热门标签

最新问答