数据库mysql存储过程Insert、update

最新推荐文章于 2024-08-15 12:27:26 发布

置顶 kabukistt3

最新推荐文章于 2024-08-15 12:27:26 发布

阅读量963

点赞数

分类专栏： mysql数据库

本文链接：https://blog.csdn.net/kabukistt3/article/details/9082087

版权

mysql数据库专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1.Insert动作

DELIMITER $$

CREATE PROCEDURE `proc_Insert`(
schoolphoto1 varchar(50),
schoolphoto2 varchar(50),
Title varchar(50),
ndescribe varchar(50),
Sort int,
IsUse int,
Url varchar(100)
)
BEGIN
insert t_carousel (schoolphoto1,schoolphoto2,Title,Note,Sort,issuer,Url)
values(schoolphoto1,schoolphoto2,Title,Note,Sort,issuer,Url);
END

2.update动作

DELIMITER $$

CREATE PROCEDURE `proc_EditCarouselById`(
id int,
schoolphoto1 varchar(50),
schoolphoto2 varchar(50),
Title varchar(50),
ndescribe varchar(50),
Sort int,
IsUse int,
Url varchar(100)
)
BEGIN
update t_carousel set
schoolphoto1=schoolphoto1,
schoolphoto2=schoolphoto2 ,
Title=Title,
Note=ndescribe,
Sort=Sort,
issuer=isnuse,
Url=Url
where carouselid=id;
END