title: .sql database import not working. (stored procedure error)
body: <p>I am new to MySQL.
  I want to import the database from .sql file.
  Tables are imported successfully.</p>
  <p>but it gives the below error regarding procedures :</p>
  <pre><code>CREATE DEFINER=`dev`@`%` PROCEDURE `sp_PlaceBet`(
      IN `pLogInId` INT,
      IN `pUserId` INT,
      IN `pParantId` INT,
      IN `pMatchId` INT,
      IN `pSelectionId` INT,
      IN `pStack` INT,
      IN `pMarketId` VARCHAR(100),
      IN `pselectionName` VARCHAR(100),
      IN `pMstDate` DATETIME,
      IN `pOdds` DECIMAL(10, 2),
      IN `pP_L` DECIMAL(10, 2),
      IN `pisBack` INT,
      IN `pIsMatched` INT,
      IN `pNarration` VARCHAR(200),
      IN `pdeviceInfo` VARCHAR(100),
      IN `pIP_ADDESSS` VARCHAR(100),
      IN `pInPlayStack` INT,
      IN `pIsApp` INT,
      IN `pType` VARCHAR(100)
  )
  BEGIN
      DECLARE LID INTEGER;
      DECLARE lCtr integer;
      DECLARE resultV INT;
      DECLARE retMess VARCHAR(500);
      DECLARE checkBal decimal(50, 2);
      DECLARE EXIT HANDLER FOR SQLEXCEPTION
      BEGIN
        set resultV = -1;
        GET STACKED DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE, @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
        SET retMess = CONCAT(&quot;ERROR &quot;, @errno, &quot; (&quot;, @sqlstate, &quot;): &quot;, @text);
        ROLLBACK;
        [...]
  MySQL said: Documentation
  
  #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'STACKED DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE, @errno = MYSQL...' at line 31
  
  </code></pre>
  <p>Please help me to solve this error.</p>
  <p>Thanks!</p>