I would like to know how to make the following stored procedure compile with MySQL Workbench version 6.3.
use puppy; DELIMITER $$ CREATE PROCEDURE spGetSystemLicensing ( IN _licenseName varchar(128) ) BEGIN IF (TRIM(_licenseName) = '') select * from SystemLicensing; ELSE select * from SystemLicensing where LicenseName=_licenseName; END IF; END
Here is my MySQL Workbench error message:
Error Code: 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 'select * from SystemLicensing' at line 8
Any help is greatly appreciated.