• Arnaud's links
  • Home
  • RSS Feed
  • Tag cloud
  • Login
all links
  • Command Line Shell For SQLite

    .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>
    

    sqlite> .mode line

    May 28, 2015 - permalink - https://www.sqlite.org/cli.html
    display sqlite