Re: [sqlite] insert two select count(*) problem

[giris]

80 ,select 
count(*) from db2 where db2.sco2>90;

Try parenthesizing each (sub)query
insert into mydb (co1,co2) (...),(...);


Could you clarify your use case for this query?

Thanks

HTH.


 From: YAN HONG YE <yanhong...@mpsa.com>
To: "sqlite-users@sqlite.org" <sqlite-users@sqlite.org> 
Sent: Wednesday, August 8, 2012 9:26 PM
Subject: [sqlite] insert two select count(*) problem
 
The sqlcmd is:
insert into mydb (co1,co2) select count(*) from db1 where db1.sco1>80 ,select 
count(*) from db2 where db2.sco2>90;
It doesn't work.  If one column, it can do,but when many column count(*), I 
don't know how to write the sql command.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] insert two select count(*) problem

[Kit]

2012/8/9 YAN HONG YE :
> The sqlcmd is:
> insert into mydb (co1,co2) select count(*) from db1 where db1.sco1>80 ,select 
> count(*) from db2 where db2.sco2>90;
> It doesn't work.  If one column, it can do,but when many column count(*), I 
> don't know how to write the sql command.

INSERT INTO mydb (co1, co2) SELECT
   (SELECT count(*) FROM db1 WHERE sco1>80),
   (SELECT count(*) FROM db2 WHERE sco2>90);
-- 
Kit
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] insert two select count(*) problem

[Keith Medcalf]

insert into mydb (co1,co2) values ((select count(*) from db1 where 
db1.sco1>80), (select count(*) from db2 where db2.sco2>90));

---
()  ascii ribbon campaign against html e-mail
/\  www.asciiribbon.org


> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of YAN HONG YE
> Sent: Wednesday, 08 August, 2012 19:27
> To: sqlite-users@sqlite.org
> Subject: [sqlite] insert two select count(*) problem
> 
> The sqlcmd is:
> insert into mydb (co1,co2) select count(*) from db1 where db1.sco1>80 ,select
> count(*) from db2 where db2.sco2>90;
> It doesn't work.  If one column, it can do,but when many column count(*), I
> don't know how to write the sql command.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



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

[sqlite] insert two select count(*) problem

[YAN HONG YE]

The sqlcmd is:
insert into mydb (co1,co2) select count(*) from db1 where db1.sco1>80 ,select 
count(*) from db2 where db2.sco2>90;
It doesn't work.  If one column, it can do,but when many column count(*), I 
don't know how to write the sql command.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users