开发者

copy one column into another column in a table

开发者 https://www.devze.com 2023-03-21 08:00 出处:网络
I have a table ID | COUNTRY | ORIGIN 1| INDIA| 2| SPAIN| 3|UK| I have c开发者_高级运维opy data from column Country to column ORIGIN.

I have a table

ID | COUNTRY | ORIGIN
1  | INDIA    |
2  | SPAIN    |
3  |  UK     |

I have c开发者_高级运维opy data from column Country to column ORIGIN. How should i do this. Please help.


UPDATE MYTABLE SET ORIGIN=COUNTRY


UPDATE my_table SET origin = country WHERE ...
0

精彩评论

暂无评论...
验证码 换一张
取 消