1、回访问题上、下排序sql语句
UPDATE table_bank bank join table_bank visit on (bank.id = 1 and visit.id = 23) or (bank.id=23 and visit.id =1) SET bank.order_no = visit.order_no, visit.order_no = bank.order_no
1、回访问题上、下排序sql语句
UPDATE table_bank bank join table_bank visit on (bank.id = 1 and visit.id = 23) or (bank.id=23 and visit.id =1) SET bank.order_no = visit.order_no, visit.order_no = bank.order_no