求一条简单的语句！！这里人气比较旺
a表
id name age
1 wang 18
2 zhang 19
3 su 20
b表
id name age
1 wang 20
2 zhang 21
3 su 22
两个表的字段完全相同
现在我需要把B表中ID为1的数据，更新到对应a表中去，如果要更新字段比较多的，求最简便的SQL语句
[解决办法]
delete from a where id = 1;
insert into a select * from b where b.id = 1;
DELETE FROM A
OUTPUT DELETED.id,DELETED.name,DELETED.age
INTO B(id,name,age)
WHERE id =1
