SELECT
column_name as '名',
column_comment as '注释',
column_type as '类型',
IF(column_key='PRI','TRUE','FALSE') AS '主键唯一',
IF(is_nullable='NO','TRUE','FALSE') AS '非空'
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
table_name = '数据表名'
SELECT
column_name as '名',
column_comment as '注释',
column_type as '类型',
IF(column_key='PRI','TRUE','FALSE') AS '主键唯一',
IF(is_nullable='NO','TRUE','FALSE') AS '非空'
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
table_name = '数据表名'
关于大数据实时数据同步flink部分测试实验
数据表碎片整理
举报文章
请选择举报类型
补充说明
0/200
上传截图
格式支持JPEG/PNG/JPG,图片不超过1.9M