SyntaxFix

[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

MYSQL PROCEDURE steps:

  1. change delimiter from default ' ; ' to ' // '

DELIMITER //

  1. 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;//
  1. Change delimiter back to ' ; '

delimiter ;

  1. Now to execute:

call ProG();

Examples related to mysql

• Implement specialization in ER diagram • How to post query parameters with Axios? • PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client • Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver' • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' is not supported • How to resolve Unable to load authentication plugin 'caching_sha2_password' issue • Connection Java-MySql : Public Key Retrieval is not allowed • How to grant all privileges to root user in MySQL 8.0 • MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Examples related to mysql-error-1064

• How to grant all privileges to root user in MySQL 8.0 • Warning about SSL connection when connecting to MySQL database • How can I fix MySQL error #1064? • MySQL Error #1133 - Can't find any matching row in the user table • MySql Inner Join with WHERE clause • Check for database connection, otherwise display message • ERROR 1064 (42000) in MySQL • mysql is not recognised as an internal or external command,operable program or batch • 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 • SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO