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

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

qt - Errors in generated MOC files for QT5 from cmake -