1Copied mysql> SHOW CREATE TABLE t\G
2*************************** 1. row ***************************
3 Table: t
4Create Table: CREATE TABLE `t` (
5 `id` int(11) NOT NULL AUTO_INCREMENT,
6 `s` char(60) DEFAULT NULL,
7 PRIMARY KEY (`id`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
1Copied mysql> DESCRIBE pet;
2+---------+-------------+------+-----+---------+-------+
3| Field | Type | Null | Key | Default | Extra |
4+---------+-------------+------+-----+---------+-------+
5| name | varchar(20) | YES | | NULL | |
6| owner | varchar(20) | YES | | NULL | |
7| species | varchar(20) | YES | | NULL | |
8| sex | char(1) | YES | | NULL | |
9| birth | date | YES | | NULL | |
10| death | date | YES | | NULL | |
11+---------+-------------+------+-----+---------+-------+