简单的update问题

[l0g]

id name tel e-mail
1 user1 110 [e-mail]
2 user2 220 [e-mail]
3 user3 330 [e-mail]

上面是一个简单的数据表! 我现在想更新id=1的记录让他的全部字段值和id=3的记录一样(id不变)!
请问应该怎样写?
注: 字段很多! 求最简洁的方法!
谢谢

[ngzhjm]

把ID=3的記錄刪除，再插入ID=1的記錄就可以了，這是最簡單的方法

[flyeq008]

学习……楼上的。。ID不变，也许别人的ID是主键呢？？

[点点星灯]

declare @tab table(id int,name varchar(20),tel varchar(20),email varchar(20))

insert @tab values(1,'user1','110','[e-mail]')
insert @tab values(2,'user2','220','[e-mail]')
insert @tab values(3,'user3','330','[e-mail]')

select * from @tab

declare @name varchar(20)
declare @tel varchar(20)
declare @email varchar(20)

select @name=[name],@tel=tel,@email=email from @tab where id=1

update @tab set [name]=@name,tel=@tel,email=@email where id=3

select * from @tab

[jin2005]

declare @tab table(id int,name varchar(20),tel int,email varchar(30))
insert into @tab
select 1,'user1',110,'[e-mail]' union
select 2,'user2',220,'[e-mail]' union
select 3,'user3',330,'[e-mail]'

update @tab set name=a.name,tel=a.tel,email=a.email from @tab,
(select id as id1,name,tel,email from @tab where id=3)a
where id=1

select * from @tab
/*
id name tel email
----------- -------------------- ----------- ------------------------------
1 user3 330 [e-mail]
2 user2 220 [e-mail]
3 user3 330 [e-mail]
*/