如何在MySQL中修改存储过程。
DROP PROCEDURE IF EXISTS sp_Country_UPDATE;
CREATE PROCEDURE sp_Country_UPDATE
( IN p_CountryId int,
IN p_CountryName nvarchar(25),
IN p_CountryDescription nvarchar(25),
IN p_IsActive bit,
IN p_IsDeleted bit )
UPDATE
Country
SET
CountryName = p_CountryName ,
CountryDescription=p_CountryDescription,
IsActive= p_IsActive,
IsDeleted=p_IsDeleted
WHERE
CountryId = p_CountryId ;
如何修改这个存储过程?
sp_Country_UPDATE
; 创建存储过程sp_Country_UPDATE
( IN p_CountryId int, IN p_CountryName nvarchar(25), IN p_CountryDescription nvarchar(25), IN p_IsActive bit, IN p_IsDeleted bit) 更新 Country 表 SET
CountryName = p_CountryName , CountryDescription=p_CountryDescription, IsActive= p_IsActive, IsDeleted=p_IsDeleted WHERE CountryId = p_CountryId ; - Tejaswi