Re: Treat results of SHOW STATUS as table == 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 |