MySQL Forums
Forum List  »  Microsoft SQL Server

Migrate a store proc from MSSQL to MySQL
Posted by: Kai Huang
Date: March 05, 2011 06:08AM

Here's the MSSQL version, I cannot convert it into MySQL version due to lack of experience. Thanks for help.

CREATE procedure [dbo].[usp_save_etl_error](
@mlsboard_id int
,@mls_id varchar(50)
,@is_data tinyint
,@is_picture tinyint
,@message varchar(1000)

IF NOT EXISTS(SELECT 1 FROM mlsassistant.dbo.etl_error WHERE mlsboard_id = @mlsboard_id AND mls_id= @mls_id AND is_fixed=0 )
INSERT INTO mlsassistant.dbo.etl_error
(mlsboard_id, mls_id, is_data, is_picture, is_fixed, message, create_date)
VALUES(@mlsboard_id, @mls_id, @is_data,
@is_picture, 0, @message, getdate() )


Options: ReplyQuote

Written By
Migrate a store proc from MSSQL to MySQL
March 05, 2011 06:08AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.