On Mon, 2007-10-08 at 02:03 -0700, chetana bhargav wrote: > SQL Guru's, > > Want to know is there any easy way to make all the columns in a particular > row to NULL other than specifying column name and NULL value, no delete as > that would change the row-id
What happens if you do: INSERT OR REPLACE INTO tbl (rowid) SELECT rowid FROM tbl WHERE <however you find the rowids>; when all the column defaults are NULL (the default default)? Dan. > -x- > Chetana > > > > ____________________________________________________________________________________ > Be a better Heartthrob. Get better relationship answers from someone who > knows. Yahoo! Answers - Check it out. > http://answers.yahoo.com/dir/?link=list&sid=396545433 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------