mysql show table info

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+---------+-------------+------+-----+---------+-------+

1# First, select your database
2USE yourDb;
3
4# Then, simply
5SHOW TABLES;

1
2-- Select all:
3
4SELECT * FROM Customers;
5