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, 4761👍, 0💬
Popular Posts:
Can you prevent a class from overriding ? If you define a class as “Sealed” in C# and “NotInheritab...
What is AL.EXE and RESGEN.EXE? In the previous question you have seen how we can use resource files ...
Can you explain steps in function points? Below are the steps in function points: >First Count ILF, ...
How can I show HTML examples without them being interpreted as part of my document? Within the HTML ...
What is the method to customize columns in DataGrid? Use the template column.