CREATE PROCEDURE spx_ImportFromExcel03
@SheetName varchar(20),
@FilePath varchar(100),
@HDR varchar(3),
@TableName varchar(50)
AS
BEGIN
DECLARE @SQL nvarchar(1000)

IF OBJECT_ID (@TableName,'U') IS NOT NULL
SET @SQL = 'INSERT INTO ' + @TableName + ' SELECT * FROM OPENDATASOURCE'
ELSE
SET @SQL = 'SELECT * INTO ' + @TableName + ' FROM OPENDATASOURCE'
END IF

SET @SQL = @SQL + '(''Microsoft.Jet.OLEDB.4.0'',''Data Source='
SET @SQL = @SQL + @FilePath + ';Extended Properties=''''Excel 8.0;HDR='
SET @SQL = @SQL + @HDR + ''''''')...['
SET @SQL = @SQL + @SheetName + ']'
EXEC sp_executesql @SQL
END

from above stored procedure in sqlserver 2005 i need this stored procedure in mysql can anyone convert this code .............

Here is the basic functionality for what you are trying to do. I do it every day and know it works, here is the flow. Be sure to  what the semicolins in my example otherwise you will get an error.

CREATE PROCEDURE name (param_name param_type)
BEGIN

DECLARE var_name data_type DEFAULT value;

IF expr THEN
    
END IF;


set varable = conditon ;

    CALL name(param_value)
 
END;