Thank you for the help, I already got the solution of the problem. Thanks! -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Wednesday, May 27, 2009 2:47 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Fast data duplication
"Vasil Boshnyakov" <vas...@voicecom.bg> wrote in message news:000c01c9de8b$16510a40$42f31e...@bg > The short description is: we need to copy many records of a table in > the same table but changing the "Name" value. So we have added a new > function which process the names: > > Insert into users ItemID, Name > Select ItemID, newName(Name) from users where itemActive = 1; > > That works great but we need one more step: how to much the pairs > "item comes from the Select <-> new item result of the Insert". We > need to track the copy history: itemID -> newItemID. What is this newItemID you speak of? As far as I can tell from your (syntactically invalid) statement, new records are inserted with the same ItemId as the old ones. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
