Row & column count (MySQL)

Uit De Vliegende Brigade
Ga naar: navigatie, zoeken

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