如题所述
replace into test_tbl (id,dr) values (1,'2'),(2,'3'),...(x,'y');
或
update
table as t1,table as t2
set
t1.phone=t2.tel
where
t1.id=t2.id