Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

MySQL Table

MySQL show tables - How do I list the tables in a MySQL database?


MySQL FAQ: How do I show/list the tables in a MySQL (or MariaDB) database (using the mysql command line client)?
To list/show the tables in a MySQL database:
  1. Log into your database using the mysql command line client
  2. Issue the use command to connect to your desired database (such as, use mydatabase)
  3. Use the MySQL show tables command, like this:
show tables;

MySQL ‘show tables’: A complete example

Here’s a slightly longer explanation. First, connect to your MySQL database using your MySQL client from your operating system command line:
$ mysql -u user1 -p
Next, after you're logged into your MySQL database, tell MySQL which database you want to use:
mysql> use kk;
Now issue the MySQL show tables command to list the tables in the current database:
mysql> show tables;
For instance, if I issue this MySQL show tables command in one of my example MySQL databases, I'll see this output:
mysql> show tables;
+-----------------------+
| Tables_in_kk |
+-----------------------+
| crust_sizes           | 
| crust_types           | 
| customers             | 
+-----------------------+
3 rows in set (0.00 sec)
That’s how you show the tables in the MySQL database using the MySQL command line client.

Comments

Popular posts from this blog

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

spfile and pfile errors

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

2017 Shortern URL - Other Website Like ADFOC.US

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory