|
View previous topic :: View next topic
|
| Author |
Message |
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. |
|
| Back to top |
|
 |
mdtendulkar
Active User
Joined: 29 Jul 2003
Posts: 237
Location: USA
|
|
|
|
program developer,
what is the key of the table?? |
|
| Back to top |
|
|
program developer
New User
Joined: 15 Nov 2005
Posts: 3
|
|
|
|
| Eid is the key. |
|
| Back to top |
|
|
|
|
