[Solved] conversion microsoft sql to mysql [closed]

Question

The syntax for selecting values into variables in MySQL is select ... into. For example you could write:

SELECT POSITION, SecPosition FROM orderdetails 
WHERE OrderID = orderDetID INTO strPos, strPosOtherRes;

The message “Not allowed to return a result set from a function” means that the select statements as they stand now would be returning a resultset from the function, and functions can only return single values.

Accepted Answer

The syntax for selecting values into variables in MySQL is select ... into. For example you could write:

SELECT POSITION, SecPosition FROM orderdetails 
WHERE OrderID = orderDetID INTO strPos, strPosOtherRes;

The message “Not allowed to return a result set from a function” means that the select statements as they stand now would be returning a resultset from the function, and functions can only return single values.