"James K. Lowden" wrote...
On Thu, 10 Oct 2013 12:29:21 -0400
"jose isaias cabrera" <cabr...@wrc.xerox.com> wrote:
> 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';
Yes, that works too. All that matters is that the values produced by
SELECT meet the requirements of the columns they're being INSERTed
into.
Muchas gracias.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
