Greetings.
I have this table creation code,
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'. I have been trying to figure this out using SQL comands, but don't
seem to get the syntax or even one command. I can do it programmatically
outside SQL,
SELECT * from SimplePrices where cust = 'XEROX';
and then replace the cust field with 'XEROX1' and INSERT OR REPLACE, but I
thought that I can ask and see if this is a possibility in one SQL command. Is
this possible?
thanks.
josé
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
