mysql show table structure code example
Example 1: mysql show all tables
show tables;
Example 2: mysql show table structure
DESCRIBE table_name;
Example 3: show table mysql
USE yourDb;
SHOW TABLES;
Example 4: show tables mysql
SHOW TABLES;
Example 5: mysql show create table
Copied mysql> SHOW CREATE TABLE t\G
*************************** 1. row ***************************
Table: t
Create Table: CREATE TABLE `t` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`s` char(60) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
Example 6: 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 | |
+