- MySQL> SELECT *
- -> FROM information_schema.COLUMNS
- -> WHERE table_schema = 'employees' AND table_name = 'departments'\G
- *************************** 1. row ***************************
- TABLE_CATALOG: def
- TABLE_SCHEMA: employees
- TABLE_NAME: departments
- COLUMN_NAME: dept_no
- ORDINAL_POSITION: 1
- COLUMN_DEFAULT: NULL
- IS_NULLABLE: NO
- DATA_TYPE: char
- CHARACTER_MAXIMUM_LENGTH: 4
- CHARACTER_OCTET_LENGTH: 12
- NUMERIC_PRECISION: NULL
- NUMERIC_SCALE: NULL
- DATETIME_PRECISION: NULL
- CHARACTER_SET_NAME: utf8
- COLLATION_NAME: utf8_general_ci
- COLUMN_TYPE: char(4)
- COLUMN_KEY: PRI
- EXTRA:
- PRIVILEGES: select,insert,update,references
- COLUMN_COMMENT:
- GENERATION_EXPRESSION:
- *************************** 2. row ***************************
- TABLE_CATALOG: def
- TABLE_SCHEMA: employees
- TABLE_NAME: departments
- COLUMN_NAME: dept_name
- ORDINAL_POSITION: 2
- COLUMN_DEFAULT: NULL
- IS_NULLABLE: NO
- DATA_TYPE: varchar
- CHARACTER_MAXIMUM_LENGTH: 40
- CHARACTER_OCTET_LENGTH: 120
- NUMERIC_PRECISION: NULL
- NUMERIC_SCALE: NULL
- DATETIME_PRECISION: NULL
- CHARACTER_SET_NAME: utf8
- COLLATION_NAME: utf8_general_ci
- COLUMN_TYPE: varchar(40)
- COLUMN_KEY: UNI
- EXTRA:
- PRIVILEGES: select,insert,update,references
- COLUMN_COMMENT:
- GENERATION_EXPRESSION:
来源: http://www.linuxidc.com/Linux/2018-12/155743.htm