News
The SQLite3 program displays its own prompt, "sqlite>" indicating that you type SQLite3 commands and not DOS commands as it's running.
This example demonstrates selecting all data from a SQLite table using the "Select *" command. If you understand SQLite "Select" commands you can tailor them to retrieve specific data from any table.
Of course, the last bit there closes the command line, but I can just take that out, and the SQLite commands should stop and sit there, right? Just return to the prompt?
The SQLite website recommends using the “sl3” extension to signify that we're working with an SQLite version 3 database. If we examine the resulting file, ljdata.sl3 using the strings command, we see ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results