下面是ms sql 的存贮过程,需要转为mysql的存贮过程?
CREATE PROCEDURE PO_test
(
@InpID VarChar(20)
)AS DECLARE @Msg VarChar(100)
IF EXISTS (SELECT 1 FROM table1 WHERE InpID=@InpID)
Begin
SET @Msg = '错误!'
RaisError(@Msg,19,1) WITH LOG
Return 0
End; select * from table1 IF (@@error = 0)
COMMIT TRANSACTION PO_ZY_Inp_DEL
ELSE
ROLLBACK TRANSACTION PO_ZY_Inp_DEL
GO请写出 mysql 的存贮过程,谢谢?
CREATE PROCEDURE PO_test
(
@InpID VarChar(20)
)AS DECLARE @Msg VarChar(100)
IF EXISTS (SELECT 1 FROM table1 WHERE InpID=@InpID)
Begin
SET @Msg = '错误!'
RaisError(@Msg,19,1) WITH LOG
Return 0
End; select * from table1 IF (@@error = 0)
COMMIT TRANSACTION PO_ZY_Inp_DEL
ELSE
ROLLBACK TRANSACTION PO_ZY_Inp_DEL
GO请写出 mysql 的存贮过程,谢谢?
CREATE PROCEDURE PO_test
(
@InpID VarChar(20)
) AS DECLARE @Msg VarChar(100)
IF EXISTS (SELECT 1 FROM table1 WHERE InpID=@InpID)
Begin
SET @Msg = '错误!'
RaisError(@Msg,19,1) WITH LOG
Return 0
End; select * from table1
GO 请写出 mysql 的存贮过程,谢谢?