MySQL Information and Resources |
Custom Search
|
Oracle | SQL Server | Sitemap
Question
How do I get a list of tables from the MySQL command line?Answer
mysql> use dborc3_sqli; Database changed
mysql> show tables; +-----------------------+ | Tables_in_dborc3_sqli | +-----------------------+ | contributor | | courses | | customers | | ensfields | | ensfiles | | heuristic | | mainmnuitem | | pagecontrib | | pgcontent | | pgcontenthdr | | pmainmnu | | sitearea | | siteareamnmnu | | siteareasubmnu | | sitecontentlicense | | siteproperties | | submnu | | submnulst | | test | +-----------------------+ 19 rows in set (0.00 sec) mysql>