MySql查询表字段信息的几种方式

SHOW FULL COLUMNS FROM test_emp;

DESCRIBE test_emp;

 

SELECT c.COLUMN_NAME,c.COLUMN_TYPE,c.COLUMN_COMMENT,c.IS_NULLABLE,c.COLUMN_DEFAULT,c.COLUMN_KEY
FROM information_schema.columns AS c
WHERE table_name = 'test_emp'
AND table_schema = 'test'
ORDER BY ORDINAL_POSITION;