数据库mysql存储过程Insert、update

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