Treat results of SHOW STATUS as table
This is a discussion on Treat results of SHOW STATUS as table within the MySQL forums, part of the Database Server Software category; --> Commands like this won't work, apparently: INSERT INTO connections SHOW STATUS LIKE 'Threads_connected'; Is there a way to put ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 10:00 AM
| ||||
| ||||
 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      |
|
02-28-2008, 10:00 AM
| ||||
| ||||
| 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 |
Linear Mode
