2.REVOKE 回收权限
" A7 w- B4 ?4 X
8 X) X. J, j) E! SREVOKE CONNECT, RESOURCE FROM 用户名; j- h# \* u3 m( `) Z
REVOKE SELECT ON 表名 FROM 用户名;
3 Y7 k# c, X, q" i: h+ NREVOKE SELECT, INSERT, DELETE ON表名 FROM 用户名1, 用户名2;7 [: _' `. n- ^" q+ p
# \5 I: _. i( `. [查询数据库中第63号错误:
$ C4 l* r7 V( v; m+ i! Jselect orgaddr,destaddr from sm_histable0116 where error_code='63';. f4 n4 f$ w! \4 v+ A
) ]: w0 A' A' u+ G8 K查询数据库中开户用户最大提交和最大下发数: select MSISDN,TCOS,OCOS from ms_usertable;9 T0 {: d% `2 c4 P. I" N
; \# Z( B7 f! L3 Q$ O4 K. C查询数据库中各种错误代码的总和:0 G, {: m5 y( I U) y; h: U
select error_code,count(*) from sm_histable0513 group by error_code order
* j' d* ]) t) G7 A5 j0 xby error_code;% I) H# d9 B0 y; _
3 p1 [: D: c9 x6 J. Q( f/ V查询报表数据库中话单统计种类查询。5 w# L' d' \# Q+ X4 |
select sum(Successcount) from tbl_MiddleMt0411 where ServiceType2=111) ?5 V; L4 ~0 b
select sum(successcount),servicetype from tbl_middlemt0411 group by servicetype |