查询某库某表表的字段信息

最新推荐文章于 2024-01-22 11:14:10 发布

麻花2013

最新推荐文章于 2024-01-22 11:14:10 发布

阅读量201

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/u012269637/article/details/86488838

版权

数据库专栏收录该内容

25 篇文章 1 订阅

订阅专栏

不加上某库，查询出来的列可能是多库的

select * from information_schema.columns where table_name = 'security_user_occupationalhistory';

select TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from information_schema.columns where table_schema ='yuncai' and table_name = 'security_user_educationbackground';
select TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from information_schema.columns where table_schema ='yuncai' and table_name = 'security_user_essentialinfo';
select TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from information_schema.columns where table_schema ='yuncai' and table_name = 'security_user_immediatefamily';
select TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from information_schema.columns where table_schema ='yuncai' and table_name = 'security_user_occupationalhistory';