语法有所不同,参见下例
mssql中一个简单存储过程例子:
CREATE PROCEDURE Delete_RCSArrester_Table
@wStationID int,
@wArresterID int
AS
BEGIN
BEGIN TRANSACTION
DELETE
FROM RCSArrester
WHERE @wStationID=wStationID AND @wArresterID=wArresterID
IF @@ERROR<>0 BEGIN
ROLLBACK TRANSACTION
RETURN -1
END
COMMIT TRANSACTION
RETURN 0
END
GO与之对应的mysql中的应该写为:
CREATE PROCEDURE `Delete_RCSArrester_Table
`(PARA_wStationID int,
PARA_wArresterID int)
BEGIN
DELETE FROM RCSArrester WHERE wStationID=PARA_wStationID AND wArresterID=PARA_wArresterID;
END
mssql中一个简单存储过程例子:
CREATE PROCEDURE Delete_RCSArrester_Table
@wStationID int,
@wArresterID int
AS
BEGIN
BEGIN TRANSACTION
DELETE
FROM RCSArrester
WHERE @wStationID=wStationID AND @wArresterID=wArresterID
IF @@ERROR<>0 BEGIN
ROLLBACK TRANSACTION
RETURN -1
END
COMMIT TRANSACTION
RETURN 0
END
GO与之对应的mysql中的应该写为:
CREATE PROCEDURE `Delete_RCSArrester_Table
`(PARA_wStationID int,
PARA_wArresterID int)
BEGIN
DELETE FROM RCSArrester WHERE wStationID=PARA_wStationID AND wArresterID=PARA_wArresterID;
END
ROLLBACK TRANSACTION
RETURN -1
END
COMMIT TRANSACTION这个判断在mysql应该如何写的?