how can i execute mysql procedure in drizzle_query

[luoqi]

like:
set $my_sql 'call p_query()';
drizzle_query $my_sql;

[agentzh]

Sorry, calling mysql procedures are currently not supported in ngx_drizzle because the underlying libdrizzle library does not support the CLIENT_MULTI_RESULTS flag yet :(

But we'll surely work on it.

[cfsego]

you have to rewrite libdrizzle to support CLIENT_MULTI_RESULTS
and if the p_query() returns many tables, very difficult to handle
i have a dirty example for a call returns one table, you can call me in