SELECT
COLUMN_NAME 字段名称,
COLUMN_TYPE 字段类型长度,
TABLE_NAME 数据库名,
COLUMN_COMMENT 字段说明
FROM
information_schema. COLUMNS
WHERE TABLE_SCHEMA = ‘cs_ticket’ AND COLUMN_NAME = ‘MAC_ADDRESS’;
mysql查看数据库字段
于 2022-10-03 16:15:18 首次发布
SELECT
COLUMN_NAME 字段名称,
COLUMN_TYPE 字段类型长度,
TABLE_NAME 数据库名,
COLUMN_COMMENT 字段说明
FROM
information_schema. COLUMNS
WHERE TABLE_SCHEMA = ‘cs_ticket’ AND COLUMN_NAME = ‘MAC_ADDRESS’;