Row & column count (MySQL)

Kolommen

select count(*) 
from information_schema.columns 
where table_name="header";

Rijen

select count(*)
from "header"

Allebei

select count(*) as "# Kolommen_superquery" from information_schema.columns where table_name="superquery";
select count(*) as "# Rijen header" from header;

Bronnen

• http://stackoverflow.com/questions/10492164/how-do-i-count-columns-of-a-table