Get all table names in php from MySQL database

Votes : 3
242
I need to help to build mysql statment to get all table names on given database.

Your Answer

1 Answer

answered
Query statements should look like :
SHOW TABLES; // or
SHOW TABLES FROM my_database; // or
SHOW TABLES FROM my_database LIKE "prefix%";

What is the codrate ?

codrate.com is a standard, fast cross browsing and highly versatile site. It is useful for many large number of Program Development Industries. So you can get support form Codrators , who are the codrate's joiners around world to help your program developments, You can answer other codrator's questions. Communicate with them. Share your knowledge with them. Do you have an interest in programming, So publish your articles about programming. It will help to maintain your professional co-profile. Actually codrate.com is not such as a regular web site. It will be gave new experience, best narrow cross-browser view, reduce processing time to receive browsing request, it's mean do not wasting your time to browsing codrate's web pages because it has been upgrade always modern coding ways. So, what do you waiting for ?. Try your own.

Copyright 2015 Pride - Company. Design by Esila