Update multiple rows in a table at a time

program developer · New User Joined: 15 Nov 2005 Posts: 3

Hi,
I have the Table structure as :
emp table
eid ename
100 abc
200 def
101 cba

is it possible to update the "ename" column in single update query?
like say for Eid =100 "abc" i want to update as "cba" and
for Eid= 101 "cba" as "abc" in a single update.
How can i do that?

Thank you in advance.

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 256 Location: USA

program developer,

what is the key of the table??

program developer · New User Joined: 15 Nov 2005 Posts: 3

Eid is the key.