Re: [sqlite] How to sort within a text field

Simon and Kit-18, thank you, I guess I'll restructure my schema. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- View this message in context:

[sqlite] How to sort within a text field

Hi all, if I have a table like CREATE TABLE [a] ( [ID] INTEGER NOT NULL, [prdtype] VARCHAR(35) NOT NULL ) and data already inserted as insert into a (ID, prdtype) values (1, '15'); insert into a (ID, prdtype) values (2, '15|10|27|3'); insert into a (ID, prdtype) values (3, '8|6|22'); and I'd

Re: [sqlite] Table insert takes very long time, please help..

Igor and Simon, thank you so much for your help. I followed your instructions and made impressive improvements. As a beginner, I learn something new. Thank's again, guys. Cheers, Rick -- View this message in context:

[sqlite] sort a contenated value as inserting

I have as the followings... create table t ([a] varchar(3), [b] varchar(3)); insert into t(a, b) values('6', '2'); insert into t(a, b) values('5', '3'); insert into t(a, b) values('2', '3'); create table t2([x] varchar(9)); insert into t2(x) select (a || ', ' || b) from t; but I want t2.x