count of the column names in phpmyadmin (mysql)

mysql, phpmyadmin, sql

Solution

For that You can write sql query in phpmyadmin.

SELECT count(*) 
FROM information_schema.columns 
WHERE table_name = '<table_name>'

Problem

this seems stupid, but I really don't know this thing. Today, I am in need to get number of properties in a mysql table (in phpmyadmin). Can I get the count of the column names in phpmyadmin (mysql)?

Original source