Out parameters in PREPARE were only available in MariaDB 10.1.1
One can use question mark placeholders for out-parameters in the PREPARE statement. Only SELECT … INTO can be used this way:
prepare test from "select id into ? from t1 where val=?"; execute test using @out, @in;
This is particularly convenient when used with compound statements:
PREPARE stmt FROM "BEGIN NOT ATOMIC DECLARE v_res INT; SELECT COUNT(*) INTO v_res FROM t1; SELECT 'Hello World', v_res INTO ?,?; END"|
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/out-parameters-in-prepare/