1,234
edits
Changes
→Command-line
Often the easiest way to create an empty database, insert test data, and test your app's usage of SQLite is the command-line tool sqlite3. On Linux it should be installed by default, on other platforms you can download and install it yourself.
<presource lang="bash"># Create the databasesqlite3 employee.db</source> <source lang="sql">
-- Now you're inside the sqlite shell, not bash. Press Ctrl+D on an empty line to quit.
-- Create a table:
.databases
-- Quit
.quit</presource>
== Test data ==