show table info mysql code example
Example 1: mysql show all tables
show tables;
Example 2: show table info mysql
Copied mysql> DESCRIBE pet;
+
| Field | Type | Null | Key | Default | Extra |
+
| name | varchar(20) | YES | | NULL | |
| owner | varchar(20) | YES | | NULL | |
| species | varchar(20) | YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| birth | date | YES | | NULL | |
| death | date | YES | | NULL | |
+
Example 3: show tables mysql
Press CTRL+C to copy SHOW [EXTENDED] [FULL] TABLES
[{FROM | IN} db_name]
[LIKE 'pattern' | WHERE expr]