show count(1) from TABLENAME;