获取mysql数据库表名、表头信息
1、查询mysql数据库所有的表名SELECT TABLE_NAME FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '库名'-- 例:select table_name from information_schema.tables where table_schema='school-info'2、获取mysql数据...
·
1、查询mysql数据库所有的表名
SELECT TABLE_NAME FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '库名'
-- 例:
select table_name from information_schema.tables where table_schema='school-info'
2、获取mysql数据库表表头所有字段
SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '库名' AND TABLE_NAME = '表名'
-- 例:
SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'school-info' AND TABLE_NAME = 'students'
更多推荐
已为社区贡献1条内容
所有评论(0)