Home » RDBMS Server » Server Administration » Deleting values of a single column
Deleting values of a single column [message #373208] Wed, 04 April 2001 06:19 Go to next message
Rashmi
Messages: 20
Registered: April 2001
Junior Member
How do I delete column values of a particular column in a table preserving the values of all other columns in the table intact?

Report message to a moderator

Re: Deleting values of a single column [message #373225 is a reply to message #373208] Thu, 05 April 2001 05:15 Go to previous message
padma
Messages: 22
Registered: April 2001
Junior Member
update emp set mgr=null;
This will set the whole column to null.

Report message to a moderator

Previous Topic: help?
Next Topic: At point of time will we be forced to drop an index on a table.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 29 05:09:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.