sql行字段内容互换

求指导谢谢
2025-04-13 12:08:29
推荐回答(2个)
回答1:

同行phone 和 mobile互换:
update customer set phone = mobile, mobile = phone where 过滤条件;

回答2:

可以啊,语句:
update customer
set phone = mobile
,mobile = phone