Why MySQL is giving error “Not allowed to return a result set from a function”?

by

Because 

SELECT left_id AS c1 FROM mlm_user_mst WHERE parent_id=a AND left_id>0;

doesn’t set the variable c1, it returns a set with a column named c1

You want

SELECT left_id INTO c1 FROM mlm_user_mst WHERE parent_id=a AND left_id>0;

Similarly for c2.

More Related Contents:

  1. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  2. Why do I get an error from this sub query script?
  3. sql query to modify the selected value from database [closed]
  4. How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?
  5. Can I concatenate multiple MySQL rows into one field?
  6. Remove duplicate rows in MySQL
  7. MySQL: @variable vs. variable. What’s the difference?
  8. How to do the Recursive SELECT query in MySQL?
  9. MySQL, update multiple tables with one query
  10. How to select a column name with a space in MySQL [duplicate]
  11. SQL Performance UNION vs OR
  12. How do I use on delete cascade in mysql?
  13. Adding a leading zero to some values in column in MySQL
  14. Using SQL to determine word count stats of a text field
  15. Update one MySQL table with values from another
  16. How to transpose mysql table rows into columns
  17. View’s SELECT contains a subquery in the FROM clause
  18. MySQL Group By and Sum total value of other column
  19. MySQL incorrect key file for tmp table when making multiple joins
  20. Does the order of conditions in a WHERE clause affect MySQL performance?
  21. Difference between these two joining table approaches?
  22. MySQL query, MAX() + GROUP BY
  23. MySQL export into outfile : CSV escaping chars
  24. Simple Random Samples from a MySQL Sql database
  25. ALTER table – adding AUTOINCREMENT in MySQL
  26. Foreign key constraints: When to use ON UPDATE and ON DELETE
  27. Syntax error: WITH is not valid input in this position
  28. MySQL – why not index every field?
  29. MySQL: Insert datetime into other datetime field
  30. Selecting distinct 2 columns combination in mysql

Leave a Comment