REPKA_Maxime_NeufBox <repka.max...@neuf.fr> wrote:
> 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

You can't do this with SQL. You'll have to do this in your application 
code.

Igor Tandetnik 



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

Reply via email to