Search code examples
mysqlmysql-error-1064

MySql error in procedure

DELIMITER $$
CREATE PROCEDURE `InsertInfo`(
    IN AId VARCHAR(20),
    IN Number VARCHAR(30),
    IN Address VARCHAR(30)
)
BEGIN
    DECLARE @BId VARCHAR(100);
    SET @BId = AId + '_' + Number + '_' + Address;
END$$

DELIMITER ;

Getting error:

Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@BId VARCHAR(100);

SET @BId = AId + '_' + Number + '_' + Address;
END' at line 7
(0 ms taken)
Solution

  • You have to remove @.

     DECLARE BId VARCHAR(100);
 SET BId = AId + '_' + Number + '_' + Address;