select distinct column_name as 字段名,column_comment as 字段备注 from information_schema.columns where table_schema = '数据库名' and table_name = '表名'
700字范文,内容丰富有趣,生活中的好帮手!
时间:2020-10-12 13:29:11
select distinct column_name as 字段名,column_comment as 字段备注 from information_schema.columns where table_schema = '数据库名' and table_name = '表名'
查询mysql表的所有字段名_查询数据库中所有表名 查询表中所有字段名
2019-01-05
mysql查询表内所以字段(查询指定表格的所有字段信息) mysql navicat登录
2022-09-07
mysql 查询所有字段名(详解mysql查询表字段名的方法) mysql备份语句怎么写
2021-11-04