Out Parameters in PREPARE
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.