例1:
create procedure proHu(in b char) select * from bb where bb=b
例2:
create procedure proHu() select * from bb
调用:
call proHu('b')
call proHu
联合查询例
select TableA.a,TableB.b
from TableA inner join
TableB on TableB.a=TableB.a
例1:
create procedure proHu(in b char) select * from bb where bb=b
例2:
create procedure proHu() select * from bb
调用:
call proHu('b')
call proHu
联合查询例
select TableA.a,TableB.b
from TableA inner join
TableB on TableB.a=TableB.a