语法有所不同,参见下例
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
解决方案 »
- MySQL Administrator Error 工具报错
- mysql交流
- 一个对于本人来说高度复杂的Sql,请高手们进来帮忙。
- 小妹请教in 'where clause' 报错的问题!
- mysql的主从复制问题
- 请教想实现这种列表如何写SQL...
- 问个数据类型的问题~~~~~~~~~~~~~~~~
- 中国首部中文版MySQL5新特性之存储过程技术手册,www.hudu.net独家发布
- 谁会用MySQL-Front,高手过来看看啊,崩溃啦!!!
- 我的mysql daemon不能启动,怎么回事?
- MySQL 5.0的存存储过程中如何抛出异常?(50分)
- MySql中有类似oracle的序列(sequence)功能吗?
ROLLBACK TRANSACTION
RETURN -1
END
COMMIT TRANSACTION这个判断在mysql应该如何写的?