select count(*) as count from r,s,d where r.owner='me' and s.owner='me' and d.owner='me';
试试!!!
试试!!!
解决方案 »
- MySQL 子查询中已经被过滤的记录还可以显示?
- 求助!Mysql 系统表
- 主从表问题!
- mysql的几个小问题
- left join 联查两张表里有重名字段的问题
- 怎么把一个从windows下拷贝到linux下的文件里的……^M字符一下字全部去掉啊?
- mysql -u root -p root pdms <d:\pdms\backdebug\0724.ful 数据导不回
- 请问postgresql数据库中 如何计算两个日期间的差距间隔
- 有那位大虾知道,如何将Linux上的MySQL的一个库移植到NT上?
- mysql复杂的建立视图问题
- 关于mysql中把一个表中中文取出,当再把它们加入另一个表就是乱码的问题?
- 请问这个sql语句怎么写?
into :li_count
from r,s,d
where r.owner='me' and
s.owner='me' and
d.owner='me';
select count(*)
into :li_count
from r,s,d
where r.owner='me' and
s.owner='me' and
d.owner='me'into:li_count是什么意思??
into :li_count
from (
select 1 from where r.owner ='me' union all
select 1 from where s.owner ='me' union all
select 1 from where d.owner ='me') as temp
INTO 是将返回值放到变量里
create table s(owner char(8));
create table t(owner char(8));
insert into r values('me');
insert into r values('me');
insert into s values('me');
insert into s values('me');
insert into s values('you');
insert into t values('me');
insert into t values('me');
insert into t values('me');
//查询
select ((select count(owner) from r where owner = 'me') + (select count(owner) from s where owner='me') + (select count(owner) from t where owner='me')) as sum
//结果
sum
-----
7是不是这个意思?