Home » RDBMS Server » Server Administration » SQL stmt
SQL stmt [message #373325] Wed, 11 April 2001 11:13 Go to next message
sharath
Messages: 5
Registered: April 2001
Junior Member
Hi all!
is it possible to replace all the occurrences of a particular data item in a table with a single SQL stmt???

Report message to a moderator

Re: SQL stmt [message #373326 is a reply to message #373325] Wed, 11 April 2001 11:36 Go to previous message
Rajiv
Messages: 14
Registered: April 2001
Junior Member
Yes.
UPDATE tablename
SET fieldname = newvalue
WHERE fieldname = oldvalue

Report message to a moderator

Previous Topic: Re: Data formats
Next Topic: SQLLOADER QUESTION
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 00:38:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.