[sqlite] Select table name and count(*) on same command

[REPKA_Maxime_NeufBox]

Hello,

Exemple of 2 SQL command :
sqlite> select name from sqlite_master where type='table';
    City
    Country
    CountryLanguage
    sqlite_stat1

sqlite> select count(*) from country;
    239

->> Could anyone tell me what is the command to get the following result :
    Table names         nb of records per table
    City                          4520
    Country                      239
    CountryLanguage        253
    sqlite_stat1                325
Thank you

Sincerely
Maxime

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users