How to Count Number of Columns in MySQL

Today, I’ve come along with another quick post to explain about how to count the number of columns in MySQL table using MySQL command.

To count a number of columns or fields is very simple and you have to have an idea about your database and table.

Let’s see the MySQL query to count the number of columns in MySQL

SELECT COUNT(*) AS Columns FROM INFORMATION_SCHEMA.COLUMNS

WHERE table_schema = 'database name' AND table_name = 'table name'

If you want to count number of columns in a table then execute above query with your database name and table name.

Comments (7)

Balasubramanya says:
January 18, 2013 at 1:05 am
thank you very good tutorial;
but i have a problem, is there any thing wrong if i use the CURSOR in a SP after some SELECT and INSERT statements.
i mean in a S/procedure is it necessary that the CURSOR should be used before all other SELECT,EDIT,DELETE statements.
because i am getting a error
Reply
Bhumi says:
January 18, 2013 at 4:35 pm
Yes CURSOR needs to be declare before Query Statement
Reply
Ryan says:
February 7, 2015 at 4:58 am
Your not counting the colomn field. Your counting the number of rows in a table.. Do you have any idea on how we can count the field like for example id,username,password.. we have 3 column counted..
Reply
1. sach says:
  May 27, 2015 at 6:06 am
  Hi ryan,
  it is working fine
  Reply
Alice says:
June 13, 2015 at 10:31 pm
I have 20 columns in a table in mysql.
Need to get the Get Counts of All the 20 Columns in that table.
Pl let me know how to do that.
Reply
1. Bhumi says:
  June 15, 2015 at 4:22 am
  Above query gives counts of column in particular table…Do you want counts of values in column?
  Reply
khairil says:
June 20, 2015 at 11:01 am
what if i want to count column that have value 1
Reply