update t_statistics_attract_smsapi a,t_statistics_attract_smsapi b
set a.ERROR_CODE=b.MOBILE,a.MOBILE=b.ERROR_CODE where a.id=b.id
mysql数据表中两列数据互换
最新推荐文章于 2024-06-27 16:42:07 发布
update t_statistics_attract_smsapi a,t_statistics_attract_smsapi b
set a.ERROR_CODE=b.MOBILE,a.MOBILE=b.ERROR_CODE where a.id=b.id