新建存储过程 mysql和PostgreSQL 等

最新推荐文章于 2024-06-29 13:00:00 发布

fwx02

最新推荐文章于 2024-06-29 13:00:00 发布

阅读量131

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/fwx02/article/details/89524326

版权

java 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

-----------------------------------------------------------------------------------------------
存储过程
-----------------------------------------------------------------------------------------------
mysql * 注意参数不要带@
create procedure proce_test (in num int(10), in xifen VARCHAR(100))
BEGIN
select * from 2006_2009demo_txt where 数量=num;
select * from 2006_2009demo_txt where 细分=xifen;
end
-----------------------------------------------------------------------------------------------
PostgreSQL 注意：$1 $2 参数如果没有LANGUAGE plpgsql 需要先创建create LANGUAGE plpgsql;

create or replace function favorite(in create_time timestamp(10))

RETURNS SETOF t_qing_app_favorite
as $BODY$
DECLARE
   select_result t_qing_app_favorite;
BEGIN
       for select_result in
           select * from t_qing_app_favorite where create_time=$1
   loop
       return next select_result;
   end loop;
   RETURN;
END
$BODY$
LANGUAGE PLPGSQL;

create or replace function junitest(in int1 bigint, in string1 VARCHAR)

RETURNS SETOF t_for_uninttest
as $BODY$
DECLARE
   select_result t_for_uninttest;
BEGIN
       for select_result in
           select * from t_for_uninttest
   loop
       return next select_result;
   end loop;
   RETURN;
END
$BODY$
LANGUAGE PLPGSQL;