mysql 存储过程 默认值
//在mssql的实现方式
CREATE PROCEDURE [dbo].[InsertNode]
@Name nvarchar(50) = N ' ',
@ServiceType int= 4,
@LicStatus int
AS
BEGIN
INSERT INTO KV_Node
(
[Name],
[ServiceType],
[LicStatus]
)
VALUES
(
@Name ,
@ServiceType
@LicStatus
)
END
//在mysql的实现方式
CREATE PROCEDURE InsertNode
_Name varchar(50) ,
_ServiceType int,
_LicStatus int
AS
BEGIN
INSERT INTO KV_Node
( Name,
ServiceType,
LicStatus
)
VALUES
(
_Name ,
_ServiceType ,
_LicStatus
)
END
大家好,遇到一个问题,在mssql里存储过程可以取到默认值,比如@N