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, 1472🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...