Re: [sqlite] sort a contenated value as inserting

On 29 September 2011 07:35, guiz wrote: > > 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]

Re: [sqlite] sort a contenated value as inserting

On Sep 29, 2011, at 8:35 AM, guiz wrote: > but I want t2.x sorted as '2, 6' , '3, 5', '2, 3' instead of '6, 2', '5, 3', > '2, 3'. well, then do do: insert into t2(x) select (b || ', ' || a) from t; ___ sqlite-users mailing list

[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