查询数据库中所有表名
SELECT
table_name
FROM
information_schema. TABLES
WHERE
table_schema = 'ibdgyht'
AND table_type = 'base table';
查询指定数据库中指定表的所有字段名column_name
SELECT
column_name
FROM
information_schema. COLUMNS
WHERE
table_schema = 'ibdgyht'
AND table_name = 'base_baidu_city'
MySql 查询数据库中所有表名
最新推荐文章于 2024-08-07 04:17:06 发布