Out Parameters in PREPARE
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"|
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.