Williams, Travis L, NPONS wrote:
Maybe I missed this somewhere.. but how do you drop a whole row
That one is easy:
delete from TABLE where col1=25;
or update a whole row with nulls easily?
Don't know that one. Would be interesting in knowing if there is a way.
The only way I can think of is to delete the row and then re-insert it,
but that depends on how the table is set up (i.e. does it allow NULL in
all fields?):
delete from TABLE where col1=25;
insert into TABLE(col1) values(25);
Just my 2 cents ...
Jc