mysql查看一张表字段总数的方法！
2018-06-04 本文已影响37人
DragonersLi
一、desc table_name 返回的总行数就是字段总数
desc anjie_work; # desc table_name
explain anjie_work;#explain table_name
image.png
二、SELECT COUNT(*) FROM information_schema.COLUMNS WHERE table_name='table_name'
SELECT COUNT(*) FROM information_schema.`COLUMNS` WHERE table_name='anjie_work' #
image.png
