查询数据库中的表
SELECT
-- a.*,
TABLE_NAME AS 表名,
TABLE_COMMENT AS 备注,
TABLE_ROWS as 数据条数
FROM
INFORMATION_SCHEMA.TABLES a
where
a.table_type = 'BASE TABLE'
and TABLE_SCHEMA = '数据库名'
order by TABLE_NAME
查询表的结构
SELECT
ORDINAL_POSITION as 序号,
-- TABLE_SCHEMA as 表名,
COLUMN_NAME AS 字段名,
DATA_TYPE AS 数据类型,
NUMERIC_PRECISION as 精度,
CHARACTER_MAXIMUM_LENGTH as 长度,
IS_NULLABLE as 空,
COLUMN_COMMENT AS 注释
FROM
INFORMATION_SCHEMA.COLUMNS a
WHERE
TABLE_SCHEMA ='数据库名'
AND TABLE_NAME = '表名'
order by ORDINAL_POSITION