Treat results of SHOW STATUS as table

Commands like this won't work, apparently:

INSERT INTO connections SHOW STATUS LIKE 'Threads_connected';

Is there a way to put the result of a status query into a table within
MySQL, or am I going to have to select and insert it in two separate
queries using PHP or a shell script?

--
cb

== Quote from Christoph Burschka (christoph.burschka@rwth-aachen.de)'s article
> Commands like this won't work, apparently:
> INSERT INTO connections SHOW STATUS LIKE 'Threads_connected';
> Is there a way to put the result of a status query into a table within
> MySQL, or am I going to have to select and insert it in two separate
> queries using PHP or a shell script?

it appears you're gonna have to use two queries and php. didn't work for me
either. strange!
--
POST BY: lark with PHP News Reader