MySQL error 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

Question

I have the Stored procedure like this   CREATE PROCEDURE ProG     BEGIN     SELECT   FROM  hs hr employee leave quota     END   But it gives the error       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    at line 3    What does the error mean   What is wrong with line number 2

User · Accepted Answer

You have to change delimiter before using triggers  stored procedures and so on   delimiter    create procedure ProG    begin  SELECT   FROM hs hr employee leave quota  end    delimiter

User · Answer

MYSQL PROCEDURE steps   change delimiter from default       to          DELIMITER      create PROCEDURE  you can refer syntax NOTE  Don t forget to end statement with          create procedure ProG    begin  SELECT   FROM hs hr employee leave quota  end       Change delimiter back to         delimiter     Now to execute    call ProG

User · Answer

Delimiters  delimiters     You really need them when there are multiple statements in your procedure   in other words  do you have a   in your code and then more statements commands  Then  you need to use delimiters    For such a simpler rpocedure as yours though  you could just do   CREATE PROCEDURE ProG     SELECT   FROM  hs hr employee leave quota

User · Answer

How to find out what this MySQL Error is trying to say    1064 - You have an error in your SQL syntax    This error has no clues in it   You have to double check all of these items to see where your mistake is    You have omitted  or included an unnecessary symbol         amp    -               lt  gt    A misplaced  missing or unnecessary keyword  select  into  or countless others    You have unicode characters that look like ascii characters in your query but are not recognized  Misplaced  missing or unnecessary whitespace or newlines between keywords   Unmatched single quotes  double quotes  parenthesis or braces     Take away as much as you can from the broken query until it starts working   And then use PostgreSQL next time that has a sane syntax reporting system

User · Answer

This might be a memmory issue on mysql try to increase max allowed packet in my ini

[mysql] MySQL error: 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

Examples related to mysql

Examples related to mysql-error-1064