Re: [sqlite] Inserting or replacing in the same db based on one key

[jose isaias cabrera]

"James K. Lowden" wrote...

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.  :-)

Thanks for the kudos and the support.  So, are you saying that this is also 
true?

INSERT INTO SimplePrices
SELECT 'XEROX1', class, slang, tlang, TransferCost, Price
FROM SimplePrices WHERE cust = 'XEROX';

I may need to also have a total different value for cust.  Thanks again.

josé

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users