Display sqlite results one column per line

sqlite3 -line database.db

Similar output to using MySQL with the \G at the end of a Query. Displays one column per line. Other modes include: -column Query results will be displayed in a table like form, using whitespace characters to separate the columns and align the output. -html Query results will be output as simple HTML tables. -line Query results will be displayed with one value per line, rows separated by a blank line. Designed to be easily parsed by scripts or other programs -list Query results will be displayed with the separator (|, by default) character between each field value. The default. From inside the command line this can be also changed using the mode command: .mode MODE ?TABLE? Set output mode where MODE is one of: csv Comma-separated values column Left-aligned columns. (See .width) html HTML code insert SQL insert statements for TABLE line One value per line list Values delimited by .separator string tabs Tab-separated values tcl TCL list elements

Sample Output

$ sqlite3 -line blackhatseo.sqlite 
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select * from auth_user;
          id = 1
    username = blabla
  first_name = 
   last_name = 
       email = blablamailinator.com
    password = blabla
    is_staff = 1
   is_active = 1
is_superuser = 1
  last_login = 2010-10-09 12:48:07.493163
 date_joined = 2010-10-09 12:48:07.493163

By: pykler

2010-10-09 16:10:19

CSV html sql sqlite

Submit An Alternative

What Others Think

Thank you for sharing, it helped me. I also wanted to share an interesting article about San Francisco and web design companies on http://medium.com/theymakedesign/web-design-agency-san-francisco-ca-d9a82db2404" >medium.com/theymakedesign/web-design-agency-san-francisco-ca-d9a82db2404. I hope that this information will be useful to someone. All the best and take care of your health in this difficult time.

klarkwhite · 205 weeks and 5 days ago

On this website, they provided lots of senior assisted living amazing information regarding the displays SQLite results one column per line.Those people who are looking for the services can make use of the information given here and also share it with your friends who are working in that area

leonamargret · 183 weeks and 5 days ago

seofox · 179 weeks and 1 day ago

seofox · 178 weeks and 2 days ago

https://absolute-iran.com https://mymakeupstory-iran.com https://londonhousedoctor.com https://ayams.ir https://foroosh-page.ir https://digitalboost.ir https://like7.ir https://karetehran.ir https://seo7x.ir https://qoou.ir https://ayams.com https://tosifyan.ir https://karekaraj.ir https://sefidii.ir https://seo7x.com https://drinstagram.com https://tabliigh.ir https://ghoyesiah.ir https://denizpet.ir https://rezabahrami.net https://damunsabt.com https://damunsabt.ir

instakade1 · 166 weeks and 5 days ago

rahimhh21 · 149 weeks and 2 days ago

Perfecthomepugs · 140 weeks and 3 days ago

pugpuppies95 · 102 weeks and 4 days ago

yeneba6574 · 57 weeks and 2 days ago

This unique is a fantastic put up I just spotted using show it again. Suggest whatever I wanted to ascertain optimism through forthcoming you are likely to remain for the purpose of showing this terrific put up. Winter Park personal trainers

jackson2321 · 19 weeks and 1 day ago

An individual's song is certainly impressive. You will have certain rather qualified musicians and artists. That i like everyone one of the best for results. ?? ??? ??

jackson2321 · 18 weeks ago

I would like to say that this blog really convinced me to do it! Thanks, very good post. slot mahjong ways 2

lowopi · 17 weeks and 2 days ago

Really unquie place, Thank you so much meant for posting The experience. Fantasticly penned report, anxieties most of folks given similar volume of material as you may, the online market place might be a a lot better put. Be sure to keep it up! field service software reviews

jackson2321 · 16 weeks and 3 days ago

An individual's song is certainly impressive. You will have certain rather qualified musicians and artists. That i like everyone one of the best for results. cash for cars Brisbane

jackson2321 · 16 weeks ago

We amazed using the evaluation a person designed to get this to specific submit amazing. Fantastic exercise! Door handles

jackson2321 · 15 weeks and 6 days ago

a extremely superb webpage. a realy educational in addition to a an extremely superior position. i’m a sucker for the. https://www.clusterrepairsuk.co.uk/

jackson2321 · 15 weeks and 1 day ago

I read your blog frequently and I just thought I’d say keep up the amazing work! https://www.spreaker.com/user/top-dynamics-partners--18364873

nnetteBeshears · 15 weeks and 1 day ago

Thank you for your submit and also fantastic suggestions.. also My partner and i furthermore believe work will be the main part of acquiring accomplishment. ???? ????

jackson2321 · 14 weeks and 4 days ago

Ones new music is usually wonderful. You could have many incredibly proficient painters. When i hope people the most beneficial connected with achievements. Wikipedia

jackson2321 · 14 weeks ago

I just concept it will be an example to write incase everyone else was basically experiencing difficulity considering and yet I'm sure a little bit of suspicious considerably more than simply morning allowed to position manufacturers not to mention talks about concerning in this case. parawany

jackson2321 · 14 weeks ago

May possibly fairly recently up and running an important web log, the data one offer you on this web site contains given a hand to all of us substantially. Bless you designed for your current precious time & get the job done. winmax

jackson2321 · 14 weeks ago

Fantastic write-up, journeyed onward in addition to book-marked your web site. When i can’t hang on to learn to read far more by people. ??? ???

jackson2321 · 13 weeks and 3 days ago

That is the excellent mindset, nonetheless is just not help to make every sence whatsoever preaching about that mather. Virtually any method many thanks in addition to i had endeavor to promote your own article in to delicius nevertheless it is apparently a dilemma using your information sites can you please recheck the idea. thanks once more. Hsrp registration

nnetteBeshears · 12 weeks and 3 days ago

Someone Sometimes with visits your blog regularly and recommended it in my experience to read as well. The way of writing is excellent and also the content is top-notch. Thanks for that insight you provide the readers! ??????? Someone Sometimes with visits your blog regularly and recommended it in my experience to read as well. The way of writing is excellent and also the content is top-notch. Thanks for that insight you provide the readers! ??????? Someone Sometimes with visits your blog regularly and recommended it in my experience to read as well. The way of writing is excellent and also the content is top-notch. Thanks for that insight you provide the readers! rogtoto login Someone Sometimes with visits your blog regularly and recommended it in my experience to read as well. The way of writing is excellent and also the content is top-notch. Thanks for that insight you provide the readers! alexistogel Someone Sometimes with visits your blog regularly and recommended it in my experience to read as well. The way of writing is excellent and also the content is top-notch. Thanks for that insight you provide the readers! olxtoto link olxtoto link

nnetteBeshears · 12 weeks and 3 days ago

Thanks For sharing this Superb article.I use this Article to show my assignment in college.it is useful For me Great Work. mobile trading platform

nnetteBeshears · 11 weeks and 5 days ago

Wow, What an Outstanding post. I found this too much informatics. It is what I was seeking for. I would like to recommend you that please keep sharing such type of info.If possible, Thanks. agenolx

nnetteBeshears · 9 weeks ago

Apa Itu Paito SGPPaito SGP adalah tampilan data hasil keluaran Singapore Pools (SGP) yang disusun dalam bentuk tabel atau warna, yang digunakan oleh pemain togel untuk menganalisa pola angka. Dengan memahami pola ini, banyak pemain bisa memprediksi angka jitu untuk taruhan berikutnya. paito sgp

nnetteBeshears · 8 weeks and 5 days ago

Thank you a bunch for sharing this with all of us you actually realize what you are talking about! Bookmarked. Please also seek advice from my site =). We could have a hyperlink change contract between us! ?? ??

nnetteBeshears · 8 weeks ago

I’ve been surfing online more than three hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. In my opinion, if all webmasters and bloggers made good content as you did, the web will be a lot more useful than ever before. 188Bet

nnetteBeshears · 8 weeks ago

howdy, your websites are really good. I appreciate your work. ???? ???

nnetteBeshears · 3 weeks and 3 days ago

Very informative post! There is a lot of information here that can help any business get started with a successful social networking campaign. DeepL???

nnetteBeshears · 2 weeks and 3 days ago

You have a real ability for writing unique content. I like how you think and the way you represent your views in this article. I agree with your way of thinking. Thank you for sharing. SoundCloud Download

nnetteBeshears · 1 week and 1 day ago

What do you think?

Any thoughts on this command? Does it work on your machine? Can you do the same thing with only 14 characters?

You must be signed in to comment.

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands

Similar Commands

Optimize Google Chrome database speedup sqlite3

Display unique values of a column

To compact all SQLite databases in your home directory

Display unique values of a column

Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for:

» all commands
» commands with 3 up-votes (commandlinefu3)
» commands with 10 up-votes (commandlinefu10)