How can I check the number of fields in a table? how can I use SQL to check the number of fields? will too many fields affect efficiency? Reference: desc & nbsp; tablebamedesc & nbsp; tablename: check how many records are returned to know how many fields are returned. of course, how can I check the number of fields in a table?
There are too many fields in the table. how can I use SQL to check the number of fields? will too many fields affect the efficiency?
------ Solution --------------------
Reference:
Desc tablebame
Desc tablename
------ Solution --------------------
Check the number of returned Records to know the number of fields.
Of course, you can also query the information_schema database.
SELECT count (*) from columns where table_name = 'Table _ name'
------ Solution --------------------
Refer to the following post
Http://bbs.csdn.net/topics/320235486
