各位大侠,小弟在工作过程中遇到一个问题,如何写sql语句存储过程的名字作为条件,能够得到此存储过程的参数类型,和参数个数
类似sqlserver中如下:select syscolumns.isoutparam
as Way,
systypes.name as TypeName
from
sysobjects,
syscolumns,
systypes
where systypes.xtype=syscolumns.xtype
and syscolumns.id=sysobjects.id
and sysobjects.name='过程名字'
order by syscolumns.isoutparam
显示结果:
Way TypeName
0 int
0 varchar
1 int
1 int
*************************************
select count(*) as RowsCount
from sysobjects,syscolumns,systypes
where systypes.xtype=syscolumns.xtype
and syscolumns.id=sysobjects.id
and sysobjects.name='过程名字'
显示结果:
RowsCount
4请大侠给出mysql的sql语句,谢谢!MySQL存储SQL
类似sqlserver中如下:select syscolumns.isoutparam
as Way,
systypes.name as TypeName
from
sysobjects,
syscolumns,
systypes
where systypes.xtype=syscolumns.xtype
and syscolumns.id=sysobjects.id
and sysobjects.name='过程名字'
order by syscolumns.isoutparam
显示结果:
Way TypeName
0 int
0 varchar
1 int
1 int
*************************************
select count(*) as RowsCount
from sysobjects,syscolumns,systypes
where systypes.xtype=syscolumns.xtype
and syscolumns.id=sysobjects.id
and sysobjects.name='过程名字'
显示结果:
RowsCount
4请大侠给出mysql的sql语句,谢谢!MySQL存储SQL
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货