728
No
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 |
댓글 ( 4)
댓글 남기기