MySQL数据库中查询表的所有列名
查询某个数据库中某个表的所有列名
1
2
| SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'tb_name';
|
查询某个数据库中某个表的所有列名,并用逗号连接
1
2
| SELECT GROUP_CONCAT(COLUMN_NAME SEPARATOR ",") FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'tb_name';
|
查询某个数据库中某个表的所有列名相关属性
1
2
3
4
5
6
7
8
| SELECT
COLUMN_NAME AS '列名',
COLUMN_COMMENT AS '备注',
IS_NULLABLE AS '是否为空',
DATA_TYPE AS '字段类型',
CHARACTER_MAXIMUM_LENGTH AS '长度'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'tb_name';
|
注意：只需要替换db_name(数据库名)和tb_name(表名)
