开发者

Duplicate Column Values MySQL

开发者 https://www.devze.com 2023-02-10 08:09 出处:网络
Is there a way I can duplicate a column\'s values into another column? IE: s_idimg_开发者_开发技巧id

Is there a way I can duplicate a column's values into another column?

IE:

s_id  img_开发者_开发技巧id
1     -
2     -
3     -
4     -

to

s_id  img_id
1     1
2     2
3     3
4     4


UPDATE your_table SET img_id = s_id;
0

精彩评论

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

关注公众号