LinuxQuestions.org - sql how to enter .mode column from command line

- Programming (https://www.linuxquestions.org/questions/programming-9/)

- - sql how to enter .mode column from command line (https://www.linuxquestions.org/questions/programming-9/sql-how-to-enter-mode-column-from-command-line-708945/)

donnied

03-03-2009 06:38 PM

sql how to enter .mode column from command line

I like running sql queries from the command line.

Code:

sqlite3 foo.db "select * from some table"

How can I specify

Code:

.mode column

at the command line?

donnied

03-03-2009 07:05 PM

oops should have looked at the man page better:

Code:

sqlite3 -column foo.db 'select * from some_table'

All times are GMT -5. The time now is 12:12 AM.