CODE EXAMPLE FOR SQL

mysql count rows returned

select count(*) from (select * from foo) as x;