How can I copy data from one column to another in the same table?

是否可以将数据从A列复制到B列中的SQL表中的所有记录？

---

How about this

UPDATE table SET columnB = columnA

This will update every row.

---

UPDATE table_name SET
    destination_column_name=orig_column_name
WHERE condition_if_necessary

链接地址: http://www.djcxy.com/p/94322.html

上一篇: INSERT SELECT语句在Oracle 11G中

下一篇: 如何将数据从一列复制到另一个表中？