MySQL Query Browser下创建存储过程和自定义函数
写MySQL,写了两个简单的
简单的存储过程:
DELIMITER $$
DROP PROCEDURE IF EXISTS wy_proc $$
CREATE PROCEDURE wy_proc (IN tname varchar(50),out outvalue datetime)
begin
set outvalue = CAST('1858-11-17' as datetime);
select outvalue;
END $$
DELIMITER ;
简单的函数:
DELIMITER $$
DROP FUNCTION IF EXISTS wy_fun $$
CREATE FUNCTION wy_fun (num varchar(50)) RETURNS datetime
begin
declare outvalue datetime;
set outvalue = CAST('1858-11-17' as datetime);
RETURN outvalue;
END $$
DELIMITER ;
相关推荐
唐文 2020-02-20
chenluhe 2019-09-05
mysqllover 2019-04-14
xiaobaif 2019-04-15
variab 2019-03-25
码农专业户 2011-12-04
愿天下再无BUG 2016-04-13
xjywp00 2019-06-20
无崖子 2018-10-23
sofast 2014-09-18
KevinMitnick 2018-08-10
这些年来 2012-08-31
wyywn 2012-05-19
hwj 2012-05-19
fuguangruomeng 2019-04-16
gmysql 2011-10-06
zhangweijin 2011-10-06
mysql0 2019-04-14