是MYSQL的命令行,开始->程序->MYSQL->MYSQL5.1->MYSQL COMMAND LINE CLINT2、检查mysql Query Browser中执行所有命令的操作键,比如在SQLYOG中是SHIFT+F9
这个语句那里有错误, SELECT sum(case when month(time_s) = 1 then time_ms/60.0 else 0), sum(case when month(time_s) = 2 then time_ms/60.0 else 0), sum(case when month(time_s) = 3 then time_ms/60.0 else 0), sum(case when month(time_s) = 4 then time_ms/60.0 else 0), sum(case when month(time_s) = 5 then time_ms/60.0 else 0), sum(case when month(time_s) = 6 then time_ms/60.0 else 0), sum(case when month(time_s) = 7 then time_ms/60.0 else 0), sum(case when month(time_s) = 8 then time_ms/60.0 else 0), sum(case when month(time_s) = 9 then time_ms/60.0 else 0), sum(case when month(time_s) = 10 then time_ms/60.0 else 0), sum(case when month(time_s) = 11 then time_ms/60.0 else 0), sum(case when month(time_s) = 12 then time_ms/60.0 else 0) FROM e_1221463846 E LEFT JOIN WEB.WEB_EVENTS_10 W ON E.EVENT_TYPE = W.TYPE_ID AND E.EVENT_ID = W.EVENT_ID WHERE W.TYPE_ID = 2
SELECT sum(case when month(time_s) = 1 then time_ms/60.0 else 0), sum(case when month(time_s) = 2 then time_ms/60.0 else 0), sum(case when month(time_s) = 3 then time_ms/60.0 else 0), sum(case when month(time_s) = 4 then time_ms/60.0 else 0), sum(case when month(time_s) = 5 then time_ms/60.0 else 0), sum(case when month(time_s) = 6 then time_ms/60.0 else 0 end ), sum(case when month(time_s) = 7 then time_ms/60.0 else 0 end ), sum(case when month(time_s) = 8 then time_ms/60.0 else 0 end ), sum(case when month(time_s) = 9 then time_ms/60.0 else 0 end ), sum(case when month(time_s) = 10 then time_ms/60.0 else 0 end ), sum(case when month(time_s) = 11 then time_ms/60.0 else 0 end ), sum(case when month(time_s) = 12 then time_ms/60.0 else 0 end ) FROM e_1221463846 E LEFT JOIN WEB.WEB_EVENTS_10 W ON E.EVENT_TYPE = W.TYPE_ID AND E.EVENT_ID = W.EVENT_ID WHERE W.TYPE_ID = 2
20楼的是WINDOWS的命令行,非MYSQL的
谢谢楼上的各位大侠帮忙,问题解决了,代码如下: SELECT sum(case when month(time_s) = 1 then time_ms/60 else 0 end), sum(case when month(time_s) = 2 then time_ms/60 else 0 end), sum(case when month(time_s) = 3 then time_ms/60 else 0 end), sum(case when month(time_s) = 4 then time_ms/60 else 0 end), sum(case when month(time_s) = 5 then time_ms/60 else 0 end), sum(case when month(time_s) = 6 then time_ms/60 else 0 end), sum(case when month(time_s) = 7 then time_ms/60 else 0 end), sum(case when month(time_s) = 8 then time_ms/60 else 0 end), sum(case when month(time_s) = 9 then time_ms/60 else 0 end), sum(case when month(time_s) = 10 then time_ms/60 else 0 end), sum(case when month(time_s) = 11 then time_ms/60 else 0 end), sum(case when month(time_s) = 12 then time_ms/60 else 0 end) FROM e_1221463846 E LEFT JOIN WEB.WEB_EVENTS_10 W ON E.EVENT_TYPE = W.TYPE_ID AND E.EVENT_ID = W.EVENT_ID WHERE W.TYPE_ID = 2
CREATE PROCEDURE TESTa()
BEGIN
DECLARE I INT;
SET I = 0;
SELECT COUNT(DB_KEY) INTO I FROM Skr2.mc_config m;
SELECT I;
END;$$
DELIMITER ;
delimiter $$
CREATE PROCEDURE TEST()
BEGIN
DECLARE I INT;
SET I = 0;
SELECT COUNT(DB_KEY) INTO I FROM Skr2.mc_config m;
SELECT I;
END;
$$
delimiter ;
You tried to execute an empty string,please type an sql command into the sql edit
fiedl and execte again.
如图:
2、检查mysql Query Browser中执行所有命令的操作键,比如在SQLYOG中是SHIFT+F9。
比如在SQLYOG中是SHIFT+F9。这个是做什么用的,我是第一次用mysql
多谢指教.
SELECT
sum(case when month(time_s) = 1 then time_ms/60.0 else 0),
sum(case when month(time_s) = 2 then time_ms/60.0 else 0),
sum(case when month(time_s) = 3 then time_ms/60.0 else 0),
sum(case when month(time_s) = 4 then time_ms/60.0 else 0),
sum(case when month(time_s) = 5 then time_ms/60.0 else 0),
sum(case when month(time_s) = 6 then time_ms/60.0 else 0),
sum(case when month(time_s) = 7 then time_ms/60.0 else 0),
sum(case when month(time_s) = 8 then time_ms/60.0 else 0),
sum(case when month(time_s) = 9 then time_ms/60.0 else 0),
sum(case when month(time_s) = 10 then time_ms/60.0 else 0),
sum(case when month(time_s) = 11 then time_ms/60.0 else 0),
sum(case when month(time_s) = 12 then time_ms/60.0 else 0)
FROM e_1221463846 E
LEFT JOIN WEB.WEB_EVENTS_10 W
ON E.EVENT_TYPE = W.TYPE_ID
AND E.EVENT_ID = W.EVENT_ID
WHERE W.TYPE_ID = 2
我在tools中发现了有一个windows command line的工具了.
大侠能不能先帮我看看这个Case语句那里有问题,我现在没用存储过程.我是用这个语句来做的.
sum(case when month(time_s) = 1 then time_ms/60.0 else 0),
sum(case when month(time_s) = 2 then time_ms/60.0 else 0),
sum(case when month(time_s) = 3 then time_ms/60.0 else 0),
sum(case when month(time_s) = 4 then time_ms/60.0 else 0),
sum(case when month(time_s) = 5 then time_ms/60.0 else 0),
sum(case when month(time_s) = 6 then time_ms/60.0 else 0 end ),
sum(case when month(time_s) = 7 then time_ms/60.0 else 0 end ),
sum(case when month(time_s) = 8 then time_ms/60.0 else 0 end ),
sum(case when month(time_s) = 9 then time_ms/60.0 else 0 end ),
sum(case when month(time_s) = 10 then time_ms/60.0 else 0 end ),
sum(case when month(time_s) = 11 then time_ms/60.0 else 0 end ),
sum(case when month(time_s) = 12 then time_ms/60.0 else 0 end )
FROM e_1221463846 E
LEFT JOIN WEB.WEB_EVENTS_10 W
ON E.EVENT_TYPE = W.TYPE_ID
AND E.EVENT_ID = W.EVENT_ID
WHERE W.TYPE_ID = 2
SELECT
sum(case when month(time_s) = 1 then time_ms/60 else 0 end),
sum(case when month(time_s) = 2 then time_ms/60 else 0 end),
sum(case when month(time_s) = 3 then time_ms/60 else 0 end),
sum(case when month(time_s) = 4 then time_ms/60 else 0 end),
sum(case when month(time_s) = 5 then time_ms/60 else 0 end),
sum(case when month(time_s) = 6 then time_ms/60 else 0 end),
sum(case when month(time_s) = 7 then time_ms/60 else 0 end),
sum(case when month(time_s) = 8 then time_ms/60 else 0 end),
sum(case when month(time_s) = 9 then time_ms/60 else 0 end),
sum(case when month(time_s) = 10 then time_ms/60 else 0 end),
sum(case when month(time_s) = 11 then time_ms/60 else 0 end),
sum(case when month(time_s) = 12 then time_ms/60 else 0 end)
FROM e_1221463846 E
LEFT JOIN WEB.WEB_EVENTS_10 W
ON E.EVENT_TYPE = W.TYPE_ID
AND E.EVENT_ID = W.EVENT_ID
WHERE W.TYPE_ID = 2