On Wed, Apr 7, 2010 at 3:46 PM, Pavel Ivanov <[email protected]> wrote: > Probably the only way to do that is > > REPLACE INTO t (id, foo, bar, ...) > SELECT 649, foo, bar, ... > WHERE id = 651 >
I get a "Error: constraint failed". I have no constraint other than INTEGER PRIMARY KEY on id. > > Pavel > > On Wed, Apr 7, 2010 at 4:33 PM, P Kishor <[email protected]> wrote: >> is there a canonical way of copying all the columns (except for the >> PKs, of course) from one row to another in the same table? I want to >> make all columns of row id = 649 in my table to become a duplicate of >> the values in row id = 651... of course, I want the id 649 to remain >> 649. >> >> UPDATE t649 >> SET >> t649.foo = t651.foo >> t649.bar = t651.bar >> .. >> (FROM table t649 ... ) <=== this is where I am drawing a blank >> >> >> -- >> Puneet Kishor _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
