LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Programming (http://www.linuxquestions.org/questions/programming-9/)
-   -   sql how to enter .mode column from command line (http://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 05:29 PM.