mysql´æÖü¹ý³Ì

## **********first test,procedure**********
#<1>
use testprocedure;
delimiter //
create procedure simpleproce1 (out par1 int)
begin
 select count(*) into par1 from proce;
end
//
delimiter ;
call simpleproce1(@a);
select @a;
#<2>,ÿ´ÎÖ»Óе¥Ò»µÄÐпÉÒÔ±»È¡»Øselect id,name into par1,par2 from proce LIMIT 1;ÖеÄLIMIT 1;
use testprocedure;
delimiter //
DROP procedure IF EXISTS simpleproce2
create procedure simpleproce2 (out par1 int,out par2 char(30))
begin
 select id,name into par1,par2 from proce LIMIT 1;
end
//
delimiter ;
call simpleproce2(@a,@b);
select @a,@b;
## *********second test,function************
#<3>
delimiter //
DROP FUNCTION IF EXISTS hello
//
create function hello(s char(20)) returns char(50)
  return concat('Hello, ',s,'!');
//
delimiter ;
select hello('world');
show create function testprocedure.hello\G
  #Ëü·µ»Ø×Ó³ÌÐòµÄÌØÕ÷£¬ÈçÊý¾Ý¿â£¬Ãû×Ö£¬ÀàÐÍ£¬´´½¨Õß¼°´´½¨ºÍÐÞ¸ÄÈÕÆÚ
show function status like 'hello'\G
#<4>
#×¢Òâname²»ÄܺÍ×Ö¶ÎÃûÏàͬ
delimiter //
DROP procedure IF EXISTS test //
CREATE PROCEDURE test ()
  BEGIN
    DECLARE name VARCHAR(5) DEFAULT 'bob';
    DECLARE newname VARCHAR(5);
    DECLARE xid INT;
   
    SELECT name,id INTO newname,xid
      from proce WHERE name = name;
    SELECT newname;
  END;
//
call test1() //
#***
delimiter //
DROP procedure IF EXISTS test2 //
CREATE PROCEDURE test2 ()
  BEGIN
   
    DECLARE newname VARCHAR(5);
    DECLARE xid INT;
   
    SELECT name,id INTO newname,xid
      from proce limit 1;
    SELECT newname,xid;
  END;
//
call test2() //
#<5>
use testprocedure;
CREATE PROCEDURE p1 () SELECT * from proce;
call p1();
#<6>×¢Òâ´Ë´¦µÄhandl