how to store output of dynamic sql statement in mysql stored procedure

[chakravarthy l]

BELOW IS MY Dynamic sql

set @Dquery = CONCAT('SELECT Count(*) FROM bankaccount ba INNER JOIN bankbranch b ON b.code = ba.BANKBRANCH_CODE INNER JOIN village v ON ba.BANKBRANCH_CODE = v.branchcode WHERE b.code=',@bank_branch_id,' AND ba.entity = ''CBS'' AND CBSACCOUNTNUMBER IS NOT NULL',' and v.CODE= ',@village_code);


PREPARE s1 FROM @Dquery;
EXECUTE s1;
DEALLOCATE PREPARE s1;

how can I store the Count(*) into a variable called _count