同行phone 和 mobile互换:update customer set phone = mobile, mobile = phone where 过滤条件;
可以啊,语句:update customerset phone = mobile ,mobile = phone