sql-server - 如何更新列sql中的所有行
问题描述
我想更新列(A)中的所有行,但该列应该填充列(B)和列(c),我应该说它应该适用于所有行
+-------+-------+-------+
| Col_B | Col_C | Col_A |
+-------+-------+-------+
| x | y | xy |
| s | u | su |
| h | z | hz |
| t | t | tt |
| m | m | mm |
解决方案
一个简单的UPDATE
语句将做你想要的:
UPDATE [mytable] SET [Col_A] = CONCAT([Col_B], [Col_C])
请注意缺少WHERE
子句将导致它应用于表中的所有行。
推荐阅读
- android - How to read a json file from resource directory in Android Studio?
- machine-learning - Not getting great results with my GNN on the MNISTSuperPixels Dataset. Can anyone spot any issues?
- discord - How do I check to see if the channel id is equal to something
- javascript - For循环的公倍数
- python - Select option problem via Selenium - Unable to locate element error
- sparql - How to get a list of Wikidata entity IDs from Wikiquote
- python - How to remove ads from a webpage with selenium in python
- django - 如何在 django 表单提交中预先/后填充 id 字段
- r - 回归:eval(predvars,data,env)中的错误:找不到对象'volt'
- java - 如何在 Java 中将元素 2 x 2 向左对齐?