Clear table row

[theoneweasel77]

Is there any quick way to clear a table row without deleting it?

 

[r937]

that's a first

no, i don't think there is an easy way

actually, deleting it and then re-adding it with only the primary key would work

but that assumes all columns are nullable

could you give some more info please?

why in the world do you need to "clear" a row?

rudy

http://r937.com/

SQL Consulting

 

[Bastien]

update the column to set everything back to the defaults (and/or)

Bastien

Cat, the other other white meat

 

[r937]

delete the row, then add it again using only the value of the primary key:

delete from yourtable where pk=937
insert into yourtable (pk) values (937)

rudy

http://r937.com/

SQL Consulting

 

[theoneweasel77]

I suppose I'll just have to update the row clearing all the entries (besides the keys). I'm designing an online game and I want to clear a move list after the script is done processing the data for that round.