CREATE PROCEDURE test()
begin
    declare tmp int;
    
    set @sql = 'select count(*) into @count_tmp from tb1';
    prepare stmt from @sql;
    execute stmt;
    set tmp = @count_tmp;
    deallocate prepare stmt;
end