Collections:
Show All Tables in a Database in MySQL
How To Get a List of All Tables in a Database in MySQL?
✍: FYIcenter.com
If you want to see the table you have just created, you can use the "SHOW TABLES" command to get a list of all tables in database. The tutorial script gives you a good example:
mysql> SHOW TABLES; +---------------+ | Tables_in_fyi | +---------------+ | links | | tip | +---------------+ 3 rows in set (0.00 sec)
⇒ Show All Columns of an Existing Table in MySQL
⇐ CREATE Command Denied Error in MySQL
2018-03-10, 1805🔥, 0💬
Popular Posts:
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...