A way to search form table in MySQL database.
Posted
by Eugene
on Stack Overflow
See other posts from Stack Overflow
or by Eugene
Published on 2010-06-15T08:25:07Z
Indexed on
2010/06/15
9:42 UTC
Read the original article
Hit count: 147
I looked for a way to scan database for a specific table. For example i have:
Database: system_ultimate Table: system_settings
And let us say, that one doesn't know precise name of the table. He only knows, that it is some how connected to word settings. How could he search for that table name then?
I understand, that usually people who develop know, what they develop, but I'm trying to get hang of MVC and I'm trying to stay as far away as possible from direct communication with table using the name.
I know, that to see all tables I could use SHOW TABLES;
© Stack Overflow or respective owner