What is wrong with this mysql stored procedure?
I use t开发者_如何学JAVAhe following mysql procedure,
DROP PROCEDURE IF EXISTS `allied`.`GetRegistrationData`$$
CREATE DEFINER=`allied`@`%` PROCEDURE `GetRegistrationData`()
BEGIN
select aboutUsId,name from aboutus where isDeleted=0
select ageId,name from age where isDeleted=0
select desiredsetId,name from desiredsetting where isDeleted=0
select disciplineId,name from discipline where isDeleted=0
select employeementId,name from employeement where isDeleted=0
select salutationId,name from salutation where isDeleted=0
select timeId,name from timetocall where isDeleted=0
END$$
DELIMITER ;
when i execute this i get an error,
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 ageId,name from age where isDeleted=0
select desiredsetId,name from desir' at line 4
Any suggestion...
you missed the semicolons at the end of each SELECT
line
You simply need to terminate your SELECT
statements with a semicolon, to fix that error.
精彩评论