SELECT column_name,column_type,IS_NULLABLE,column_key FROM information_schema.columns WHERE
table_schema= '库名' AND table_name = '表名'
sql 查询库中某表中所有字段及字段类型、属性等
最新推荐文章于 2024-08-20 22:53:45 发布
SELECT column_name,column_type,IS_NULLABLE,column_key FROM information_schema.columns WHERE
table_schema= '库名' AND table_name = '表名'