Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Show All Tables with "mysql"
How To Show All Tables with "mysql"? - MySQL FAQs - Administrator Tools for Managing MySQL Server
✍: FYIcenter.com
If you want to see all the tables in a database, you run the non-SQL command "SHOW TABLES" at the "mysql" prompt. See the following tutorial exercise for example:
>cd \mysql\bin >mysql -u root test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 14 to server version: 5.0.24 mysql> SHOW TABLES; +----------------+ | Tables_in_test | +----------------+ | links | +----------------+ 1 row in set (0.01 sec)
The output shows you that there is only one table in the "test" database.
2007-05-11, 4685👍, 0💬
Popular Posts:
How To Merge Cells in a Column? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells If you ...
How To Check the Oracle TNS Settings? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Con...
What Articles Have You Read about JUnit? There are a number of JUnit articles that you should read: ...
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, ...
How To Escape Special Characters in SQL statements? - MySQL FAQs - Introduction to SQL Basics There ...