56,677
社区成员
发帖
与我相关
我的任务
分享关于mysql的function~~~
按照网上的教程，写了个小练习，可是报错 求大神帮忙看看 赳赳错
DELIMITER //
create function get_tot_ords(in c_num int) Returns double
Begin
declare tot_ord double;
select sum(amount) into tot_ord from orders where cust = c_num;
return tot_ord;
End;
//
DELIMITER //
create function get_tot_ords(in c_num int) Returns double
Begin
declare tot_ord double;
select sum(amount) into tot_ord from orders where cust = c_num;
return tot_ord;
End;
//
...全文
请发表友善的回复…
发表回复
tutty 2011-10-21
- 打赏
- 举报
[Quote=引用 3 楼 wwwwb 的回复:]
命令行+SQLYOG
[/Quote]
谢谢提点
命令行+SQLYOG
[/Quote]
谢谢提点
wwwwb 2011-10-21
- 打赏
- 举报
命令行+SQLYOG
tutty 2011-10-21
- 打赏
- 举报
[Quote=引用 1 楼 wwwwb 的回复:]
DELIMITER //
DROP FUNCTION IF EXISTS get_tot_ords//
CREATE FUNCTION get_tot_ords(c_num INT) RETURNS DOUBLE
BEGIN
DECLARE tot_ord DOUBLE;
SELECT SUM(amount) INTO tot_ord FROM orders WHERE cust ……
[/Quote]
大神用的是什么工具啊 ？
DELIMITER //
DROP FUNCTION IF EXISTS get_tot_ords//
CREATE FUNCTION get_tot_ords(c_num INT) RETURNS DOUBLE
BEGIN
DECLARE tot_ord DOUBLE;
SELECT SUM(amount) INTO tot_ord FROM orders WHERE cust ……
[/Quote]
大神用的是什么工具啊 ？
wwwwb 2011-10-21
- 打赏
- 举报
DELIMITER //
DROP FUNCTION IF EXISTS get_tot_ords//
CREATE FUNCTION get_tot_ords(c_num INT) RETURNS DOUBLE
BEGIN
DECLARE tot_ord DOUBLE;
SELECT SUM(amount) INTO tot_ord FROM orders WHERE cust = c_num;
RETURN tot_ord;
END;//
DELIMITER ;
DROP FUNCTION IF EXISTS get_tot_ords//
CREATE FUNCTION get_tot_ords(c_num INT) RETURNS DOUBLE
BEGIN
DECLARE tot_ord DOUBLE;
SELECT SUM(amount) INTO tot_ord FROM orders WHERE cust = c_num;
RETURN tot_ord;
END;//
DELIMITER ;
