View Single Post
  #2 (permalink)  
Old 06-11-2007, 06:46 PM
lark
 
Posts: n/a
Default 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
Reply With Quote