开发者

What is wrong with this mysql stored procedure?

开发者 https://www.devze.com 2022-12-27 08:54 出处:网络
I use t开发者_如何学JAVAhe following mysql procedure, DROP PROCEDURE IF EXISTS `allied`.`GetRegistrationData`$$

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消