Probably the only way to do that is REPLACE INTO t (id, foo, bar, ...) SELECT 649, foo, bar, ... WHERE id = 651
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 > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
