Solution :
You have to change the delimiter before using the triggers, stored procedures and so on as shown below .
delimiter //
create procedure MyProG()
begin
SELECT * FROM hs_hr_employee_leave_quota;
end;//
delimiter ;
OR
Guide to find out what your MySQL Error is trying to say as below:
#1064 - You have an error in your SQL syntax;
Above error has no clues in it. So you have to double check all of your items to see where the mistake is:
1. You must have either omitted, or included an unnecessary symbol: !@#$%^&*()-_=+[]{}\|;:'",<>/?
2. You must have included a misplaced, missing or unnecessary keyword: select, into, or the countless others.
3. You must have unicode characters that look like ascii characters in the query but are not recognized.
4. Misplaced, missing or the unnecessary whitespace or a newlines between keywords.
Remove as much as you can from your broken query until it starts working. And then use PostgreSQL next time that has a sane syntax reporting system.