select count(*)
from information_schema.COLUMNS
where TABLE_SCHEMA='库名' and table_name='表名'
mysql查询一个表共有多少列数
最新推荐文章于 2024-05-30 07:37:59 发布
select count(*)
from information_schema.COLUMNS
where TABLE_SCHEMA='库名' and table_name='表名'