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