On Wed, 9 Oct 2013 17:00:36 -0400 "jose isaias cabrera" <cabr...@wrc.xerox.com> wrote:
> CREATE TABLE SimplePrices ( > cust TEXT, > class TEXT, > slang TEXT, > tlang TEXT, > TransferCost, > Price, > PRIMARY KEY (cust, class, slang, tlang)); > > and I have lots of data data. What I would like to do is to be able > to copy records to the same table. So, imagine that you have a set > of records where cust='XEROX' and you would like to copy all of those > records to a new cust say, 'XEROX1'. INSERT INTO SimplePrices SELECT cust || '1', class, slang, tlang, TransferCost, Price FROM SimplePrices WHERE cust = 'XEROX'; Kudos for the primary key declaration, btw. :-) --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
