Mysql – cannot create a procedure with error [1064] [42000]

MySQLmysql-5.7

I am using mysql 5.7 and I have some code which works. But when I try to create procedure with the code, it reports error [1064] [42000]. I try to update the content of an old procedure with my current code and it works. Does someone know why this happens?

Here is how I try to create a procedure.

create procedure dispatch_remaintimecal_12division (in lgtid VARCHAR(20))
begin
my code;
end

Best Answer

ERROR 1064 (42000): states that "You have an error in your SQL syntax". Can you specify what is being executed as 'my code'. That is where SQL syntax appears to be going wrong. Make sure you are within the right database before calling your procedure.

eg: USE dbname;

Related Solutions

MySQL Syntax Error 1064 On Set

The IP Addresses in your DNSx_tmp variables need to be enclosed in single quotes in order to make them character strings (as they have been Declared).

The SET DNSx_tmp; variables need to be moved below all the DECLARE statements.

You also need to add a BEGIN clause above DECLARE c_user and the matching END clause before your final ENDclause.

MySQL – Why Stored Procedure Doesn’t Compile in Workbench 6.3

You're just missing the keyword THEN. Read more about the correct syntax here.

Try it like this:

use puppy;
DELIMITER $$
CREATE PROCEDURE spGetSystemLicensing
(
    IN  _licenseName varchar(128)
)
BEGIN

IF (TRIM(_licenseName) = '') THEN
    select * from SystemLicensing; 
ELSE
    select * from SystemLicensing where LicenseName=_licenseName;
END IF;

END $$
DELIMITER ;

Best Answer

Related Solutions

MySQL Syntax Error 1064 On Set

MySQL – Why Stored Procedure Doesn’t Compile in Workbench 6.3

Related Question