如何禁用mysql响铃？

mysql有一个参数：-b

-b, --no-beep Turn off beep on error.

在执行mysql命令行时加上这个-b参数即可禁止错误出现时的响铃。

这个是SQL SERVER的语法，MY SQL的思路应该是类似的

---------------------------------------------------------

select

*

from

(select

isnull(sum(online_count),0) h16

from

#a

where

datepart(hh,watch_time)=16) a,

(select

isnull(sum(online_count),0) h17

from

#a

where

datepart(hh,watch_time)=17) b,

(select

isnull(sum(online_count),0) h18

from

#a

where

datepart(hh,watch_time)=18) c,

(select

isnull(sum(online_count),0) h19

from

#a

where

datepart(hh,watch_time)=19) d

你把查询出来的结果 logo01|uploadfile/2010/0323/20100323015239717.gif

用"|"分割，然后只取后面一段不可以吗?

或者SQL语句这样写

SELECT SUBSTRING(`downurls`, 8, length(downurls)) FROM `cook_c_down`

---