I have searched the MySQL manual for something, and I am sure it has to be there; I just am unable to find it. So, I come to my fellow "code monkeys" to see if they know.
I am currently building a GUI (with php) for MySQL databases. With individual tables I can query a string like, "Show table status from main;", and it will return to me a bunch of information about the various tables I have set up. My question is, is there a way to "Show Database status" to return the same information that table status shows. :question:
I am currently building a GUI (with php) for MySQL databases. With individual tables I can query a string like, "Show table status from main;", and it will return to me a bunch of information about the various tables I have set up. My question is, is there a way to "Show Database status" to return the same information that table status shows. :question: