Hi All,
I am trying to create a Procedure in MySQL but it is not getting compiled. I have used a simple Code to test it.
CREATE PROCEDURE curdemo
BEGIN
DECLARE a CHAR(16);
DECLARE b, c INT;
END;
I am getting the below error
mysql> \. /home/esuvsen/Desktop/TAG Allignment/TEST.sql
ERROR 1064 (42000): 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 'BEGIN
DECLARE a CHAR(16);
DECLARE b, c INT;
END' at line 2
I have also changed to Delimiter to // using the below command at the MySQL Prompt
Delimiter //
Please help..
] 
Blog
Search
Help
Members
Register
Login
Home
