Access denied; you need the SUPER privilege for this operation
ERROR
This Stored Procedure used to only on Localhost
This Stored Procedure used to only on Server Side
ERROR
This Stored Procedure used to only on Localhost
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_delete_course`(In eid INT)
BEGIN
delete from `courses` where courseid=eid;
END
REMOVE
DEFINER=`root`@`localhost`
Working Query
CREATE PROCEDURE `sp_delete_course`(In eid INT)
BEGIN
delete from `courses` where courseid=eid;
END
Before Uploading to the Server
Clear DEFINER=`root`@`localhost` than working fine
0 comments:
Post a Comment