I tried to do that, and hit walls all over the place. My solution was to import the table into OpenOffice Calc and move the columns around there. Not too elegant, but it worked.
Ted 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 > -- _____________________________________________________________________ 3.14159265358979323846264338327950 Let the spirit of pi 2884197169399375105820974944592307 spread all over the world! 8164062862089986280348253421170679 http://pi314.at PI VOBISCUM! ============================================ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
