解决方案 »
- mysql大数据多表连接查寻求解
- 求一个Mysql的定时任务。新手级别。
- 急,在线等待 //PG表中数据被破坏,如何恢复啊,
- postgresql用户定义c函数的调试
- mysql的触发器大家都在什么情况下使用
- MySQL的分离问题...
- select a+b from tbc 其中 a 和 b 都是 varchar类型的,这样的sql在pg里怎么写
- 难题求解:往100万条数据中插入1万条,有什么好的办法提高效率?
- 请教,Berkeley DB 与 MySQL中Berkeley DB事务性存储引擎的区别
- 设计一个对从网站爬到的数据进行筛选操作的数据库的思路
- mysql求助可以替换部分文字内容吗
- 请教一个sql语句
sum(clickNum),sum(commNum),sum(shareNum)
from (
select shortUrl,
SUBSTRING_INDEX(countString23,',',1)+0 as clickNum,
SUBSTRING_INDEX(SUBSTRING_INDEX(countString23,',',2),',',-1)+0 as commNum,
SUBSTRING_INDEX(countString23,',',-1)+0 as shareNum
from url_20130519_hour
) a ,main_info_01 b
where a.shortUrl=b.shortUrl
group by b.userId
insert into url_20130519_count values
select 语句确实生成了我想要的数据。
use wburl;
insert into url_20130519_count values(select b.userId,count(*) as myCount,
sum(clickNum) as clickNum ,sum(commNum) as commNum,sum(shareNum) as shareNum
from ( select shortUrl, SUBSTRING_INDEX(countString23,',',1)+0 as clickNum, SUBSTRING_INDEX(SUBSTRING_IND
EX(countString23,',',2),',',-1)+0 as commNum,
SUBSTRING_INDEX(countString23,',',-1)+0 as shareNum from url_20130519_hour ) a ,main_info_01 b where a.shortUrl=b.shortUrl
group by b.userId);请版主继续帮忙啊,谢谢!
是这个样子?use wburl;
insert into url_20130520_count select userId,myCount,clickNum,commNum,shareNum from (select b.userId,count(*) as myCount,
sum(clickNum) as clickNum ,sum(commNum) as commNum,sum(shareNum) as shareNum
from ( select shortUrl, SUBSTRING_INDEX(countString23,',',1)+0 as clickNum, SUBSTRING_INDEX(SUBSTRING_IND
EX(countString23,',',2),',',-1)+0 as commNum,
SUBSTRING_INDEX(countString23,',',-1)+0 as shareNum from url_20130519_hour ) a ,main_info_01 b where a.shortUrl=b.shortUrl
group by b.userId);
报错:
ERROR 1248 (42000) at line 4: Every derived table must have its own alias求指点啊,