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
