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, 1224👍, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard ...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...