SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '数据库名'
select table_schema,table_name,column_name from information_schema.columns order by table_schema,table_name
文章标签 mysql 查询 动态表名 数据库 文章分类 MySQL 数据库
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '数据库名'
select table_schema,table_name,column_name from information_schema.columns order by table_schema,table_name
举报文章
请选择举报类型
补充说明
0/200
上传截图
格式支持JPEG/PNG/JPG,图片不超过1.9M