SELECT
TABLE_NAME ,
COLUMN_NAME ,
COLUMN_TYPE ,
IF
( IS_NULLABLE = 'YES', '是', '否' ) ,
IF
( COLUMN_KEY = 'PRI', '是', '否' ) ,
COLUMN_COMMENT
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_SCHEMA = 'enn_md_order'
AND TABLE_NAME = 'x_order_main';
mysql导出表字段,属性
最新推荐文章于 2024-06-28 16:34:54 发布