phpMyAdmin error: Cannot return a ResultSet in the Given Context in mysql -
please have @ code below:
delimiter $$ drop procedure `mostpopular` create procedure `mostpopular`() begin drop view if exists mostrec; create view mostrec select count(*) ord,course_code cms.courses_viewed group course_code; select course_name course join mostrec on course.course_code=mostrec.course_code order ord desc; end this code works in mysql workbench not work in phpmyadmin. prints "cannot return resultset in given context in mysql". know why might happening?
most because pma doesn't use mysqli_multi_query can test making php script executes procedure using mentioned function
Comments
Post a Comment