mysql查詢數(shù)據(jù)庫所有的表以及字段信息
SELECT
?? ?table_schema 數(shù)據(jù)庫名,
? table_name 表名,
? COLUMN_NAME 列名,
? COLUMN_TYPE 數(shù)據(jù)類型,
? DATA_TYPE 字段類型,
? CHARACTER_MAXIMUM_LENGTH 長度,
? IS_NULLABLE 是否為空,
? COLUMN_DEFAULT 默認(rèn)值,
? COLUMN_COMMENT 備注?
FROM
?INFORMATION_SCHEMA.COLUMNS
where
-- table_schema 為庫名
table_schema ='XXX'
AND
-- table_name為表名
table_name ?in (SELECT table_name FROM (SELECT table_name, table_comment, create_time, update_time FROM information_schema.tables
WHERE table_schema = (SELECT DATABASE())
ORDER BY create_time DESC) as t )文章來源：http://www.zghlxwxcb.cn/news/detail-480583.html
clickhouse導(dǎo)出表信息
SELECT
? ? database AS `數(shù)據(jù)庫名`,
? ? table AS `表名`,
? ? name AS `列名`,
? ? type AS `類型`,
? ? default_expression AS `默認(rèn)值`,
? ? numeric_precision AS `數(shù)字精度`,
? ? numeric_scale AS `小數(shù)位數(shù)`,
? ? comment AS `字段說明`?
FROM
? ? system.columns
WHERE
? ? database='default'?文章來源地址http://www.zghlxwxcb.cn/news/detail-480583.html
到了這里，關(guān)于mysql、clickhouse查詢數(shù)據(jù)庫所有的表以及字段信息的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
