Count MYSQL Columns


MYSQL Count Columns

To count all columns of a mysql database table,

1) Open PHPMYADMIN
2) Select 'SQL' tab.
3) Type Command:
  SELECT count(*) FROM information_schema.`COLUMNS` C
  WHERE table_name = 'mytable';