SELECT  
COLUMN_NAME 'Name',
DATA_TYPE 'Type',
COLUMN_TYPE 'Byte',
COLUMN_KEY 'Key',
IS_NULLABLE 'NULL',
COLUMN_DEFAULT 'Default',
COLUMN_COMMENT 'Desciption',
EXTRA 'option'
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_SCHEMA = 'company' 
AND TABLE_NAME = 'product'
ORDER BY TABLE_NAME, ORDINAL_POSITION  

 

 

 

bigint	bigint(20) unsigned	PRI	NO		pseq		auto_increment
varchar	varchar(100)		NO		p_name
varchar	varchar(20)		NO		manufacture_company
date	date		NO		manufacture_date
date	date		NO		expiration_date
float	float(4,2)		NO		price
smallint	smallint(6)	MUL	NO		department_dnumber