存储过程基本写法

最新推荐文章于 2025-11-02 18:41:36 发布

原创最新推荐文章于 2025-11-02 18:41:36 发布 · 7.6k 阅读

13 ·

CC 4.0 BY-SA版权

数据库专栏收录该内容

1 篇文章

订阅专栏

本文详细介绍如何使用存储过程进行数据管理，包括添加、显示、删除、反填和修改数据的具体操作步骤。

/添加存储过程/
DROP PROCEDURE IF EXISTS Add_address;
CREATE PROCEDURE Add_address(_AName VARCHAR(50),_Pid int)
BEGIN
insert into Address values(0,_AName,_Pid);
END;
CALL Add_address(‘锦州市’,3)

/显示存储过程/
DROP PROCEDURE IF EXISTS Show_address;
CREATE PROCEDURE Show_address()
BEGIN
SELECT * FROM Address;
END;
CALL Show_address

/删除存储过程/
DROP PROCEDURE IF EXISTS Del_address;
CREATE PROCEDURE Del_address(_Id int)
BEGIN
DELETE from Address WHERE Id = _Id;
END;
CALL Del_address(18);

/反填存储过程/
DROP PROCEDURE IF EXISTS Back_address;
CREATE PROCEDURE Back_address(_Id int)
BEGIN
SELECT * FROM Address where Id = _Id;
END;
CALL Back_address(7);

/修改存储过程/
DROP PROCEDURE IF EXISTS Edit_address;
CREATE PROCEDURE Edit_address(_Id int,_AName VARCHAR(50))
BEGIN
UPDATE Address set AName = _AName WHERE Id = _Id;
END;
CALL Edit_address(7,‘奉贤区’);