要列出表中的所有列,我们可以使用SHOW命令。让我们首先创建一个表。mysql> create table ColumnsList
-> (
-> id int,
-> Firstname varchar(200),
-> LastName varchar(100),
-> Age int,
-> Address varchar(300),
-> CollegeName varchar(100)
-> );
列出所有列名称的语法。show columns from yourTableName;
以下是输出。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)