How do I count columns of a table

Question

For example    tbl ifo  id   name    age   gender  ---------------------------- 1    John     15    Male 2    Maria    18    Female 3    Steph    19    Female 4    Jay      21    Male   How can I count the columns of this table using mysql

User · Answer

I think you want to know the total entries count in a table  For that use this code    SELECT count      as  Total Entries FROM tbl ifo

User · Answer

I think you need also to specify the name of the database   SELECT COUNT    FROM INFORMATION SCHEMA COLUMNS WHERE table schema    SchemaNameHere    AND table name    TableNameHere    if you don t specify the name of your database  chances are it will count all columns as long as it matches the name of your table  For example  you have two database  DBaseA and DbaseB  In DBaseA  it has two tables  TabA 3 fields   TabB 4 fields   And in DBaseB  it has again two tables  TabA 4 fields   TabC 4 fields    if you run this query   SELECT count    FROM information schema columns WHERE table name    TabA    it will return 7 because there are two tables named TabA  But by adding another condition table schema    SchemaNameHere    SELECT COUNT    FROM INFORMATION SCHEMA COLUMNS WHERE table schema    DBaseA    AND table name    TabA    then it will only return 3

User · Answer

Simply use mysql fetch assoc and count the array using count   function

User · Answer

I have a more general answer  but I believe it is useful for counting the columns for all tables in a DB   SELECT table name  count    FROM information schema columns GROUP BY table name

User · Answer

To count the columns of your table precisely  you can get form information schema columns with passing your desired Database Schema  Name and Table Name    Reference the following Code   SELECT count    FROM information schema columns WHERE table schema    myDB    AND table name    table1

User · Answer

SELECT count    FROM information schema columns WHERE table name    tbl ifo

User · Answer

this query may help you  SELECT COUNT COLUMN NAME  FROM INFORMATION SCHEMA COLUMNS WHERE  TABLE CATALOG    database  AND TABLE SCHEMA    dbo  AND TABLE NAME    tbl ifo

User · Answer

cs   mysql query  describe tbl info     column count   mysql num rows  cs     Or just    column count   mysql num rows mysql query  describe tbl info

[mysql] How do I count columns of a table

Examples related to mysql

Examples related to sql