.mode line

Quand meme bien plus lisible que le mode par défaut pour afficher 1 entrée

In "line" mode, each column in a row of the database is shown on a line by itself. Each line consists of the column name, an equal sign and the column data. Successive records are separated by a blank line. Here is an example of line mode output:

sqlite> .mode line
sqlite> select * from tbl1;
one = hello
two = 10

one = goodbye
two = 20
sqlite>

requete top mineur tout minerai confondu :
SELECT player,COUNT(*) AS total FROM block GROUP BY player ORDER BY total DESC

requete top mineur d'un block en particulier :
SELECT player,COUNT(*) AS total FROM block WHERE id='15' GROUP BY player ORDER BY total DESC

Pour faire des requetes tout ça :
http://forums.bukkit.org/threads/lib-tut-mysql-sqlite-bukkit-drivers.33849/
http://java.developpez.com/faq/jdbc/?page=resultset#valeursRS
http://java.developpez.com/faq/jdbc/?page=metadataresultset