Cách liệt kê tất cả cột trong bảng MySQL?

Dùng lệnh SHOW COLUMNS.

Tạo bảng

mysql> CREATE TABLE ColumnsList (
    -> id INT,
    -> Firstname VARCHAR(200),
    -> LastName VARCHAR(100),
    -> Age INT,
    -> Address VARCHAR(300),
    -> CollegeName VARCHAR(100)
    -> );
Query OK, 0 rows affected (1.33 sec)

Cú pháp

SHOW COLUMNS FROM TenBangCuaBan;

mysql> SHOW COLUMNS FROM ColumnsList;

+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| id          | int(11)      | YES  |     | NULL    |       |
| Firstname   | varchar(200) | YES  |     | NULL    |       |
| LastName    | varchar(100) | YES  |     | NULL    |       |
| Age         | int(11)      | YES  |     | NULL    |       |
| Address     | varchar(300) | YES  |     | NULL    |       |
| CollegeName | varchar(100) | YES  |     | NULL    |       |
+-------------+--------------+------+-----+---------+-------+
6 rows in set (0.00 sec)