方法1:
SELECT * from Information_schema.columns where table_Name='表名';
结果如下:
TABLE_CATALOG: NULL
TABLE_SCHEMA: mydb
TABLE_NAME: t_xxxx
COLUMN_NAME: lastmodifytime
ORDINAL_POSITION: 28
COLUMN_DEFAULT: NULL
IS_NULLABLE: YES
DATA_TYPE: datetime
CHARACTER_MAXIMUM_LENGTH: NULL
CHARACTER_OCTET_LENGTH: NULL
NUMERIC_PRECISION: NULL
NUMERIC_SCALE: NULL
CHARACTER_SET_NAME: NULL
COLLATION_NAME: NULL
COLUMN_TYPE: datetime
COLUMN_KEY:
EXTRA:
PRIVILEGES: select,insert,update,references
COLUMN_COMMENT:
28 rows in set (0.01 sec)
方法2:
desc 表名;
方法3:
show create table 表名;