MySQL Stored Procedures not working with SELECT (basic question)

by

Figured it out. This is not a bug with PHP (though it used to be) – it’s a bug in some versions of phpmyadmin. The same bug intermittently reappears and is then fixed in various subversions (see above):

#1312 - PROCEDURE [name] can't return a result set in the given context

This behavior appears limited to SELECT statements within stored procedures inside phpmyadmin.

Using a client like MySQL Workbench works around the problem (or you could upgrade phpmyadmin, but that’s a pain if you’re on a shared server like I am).

Anyway, thanks to everyone for your help.

More Related Contents:

  1. Connect By Prior Equivalent for MySQL
  2. MySQL create stored procedure syntax with delimiter
  3. mysql dynamic query in stored procedure
  4. MySQL : transaction within a stored procedure
  5. Split a string and loop through values in MySQL stored procedure
  6. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  7. What is dynamic SQL?
  8. SQL Query needed for fetch value from Two identical table but not fully identical table
  9. Error related to only_full_group_by when executing a query in MySql
  10. SQL split values to multiple rows
  11. How to reset AUTO_INCREMENT in MySQL
  12. How to declare a variable in MySQL?
  13. MySQL Query GROUP BY day / month / year
  14. MySQL Cannot Add Foreign Key Constraint
  15. Grouping into interval of 5 minutes within a time range
  16. SQL counting all rows instead of counting individual rows
  17. Convert timestamp to date in MySQL query
  18. Update a column value, replacing part of a string
  19. MySQL Like multiple values
  20. In MySQL, should I quote numbers or not?
  21. MySQL add days to a date
  22. Check for x consecutive days – given timestamps in database
  23. How to select one row randomly taking into account a weight?
  24. Composite key as foreign key (sql)
  25. MySQL query, MAX() + GROUP BY
  26. MySQL export into outfile : CSV escaping chars
  27. Simple Random Samples from a MySQL Sql database
  28. ALTER table – adding AUTOINCREMENT in MySQL
  29. MySQL Select minimum/maximum among two (or more) given values
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment