David Smith

David Smith

  • NA
  • 2k
  • 0

MySql Syntax

Feb 8 2012 4:31 PM
I am Sql Server 2008 guy, I am using MySql for the first the time, the syntax is kicking my butt for the stored procedure. Can you tell me what i am doing wrong below. I am getting the error in the where clause.

-- --------------------------------------------------------------------------------
-- Routine DDL
-- Note: comments before and after the routine body will not be stored by the server
-- --------------------------------------------------------------------------------
DELIMITER $$

CREATE PROCEDURE `sm3iiasensorseekerdatabase`.`prc_GetTestInfoBycolorSerialNumber`
(
  IN    colorSerialNumber     VARCHAR (50)
)
BEGIN

SELECT    
        table1.colorSerialNumber,
        table1.colorPartNumber,
        table1.comments,
        table2.ID,
        table2.colorName,
        table2.colorCreationStartTime ,
        table2.colorOperator
       
    
FROM         table1     INNER JOIN
                              table2 ON seeker.colorPartNumber = table2.color_PartNumber AND
                              table1.colorSerialNumber = table2.color_SerialNumber                

WHERE    (table1.SerialNumber Like '' + @colorSerialNumber + '%');

END



Answers (2)