We have four records that contain double вЂњlвЂќ in the last name, and theyвЂ™re sorted alphabetically by state, from Arizona to Wisconsin. The results are displayed in the lower pane. Click the blue arrow (it looks like a вЂњPlayвЂќ button) to run your SQL command. This will search for people with a double вЂњlвЂќ in their last name, and the results will be sorted by state. WeвЂ™ve added the following SQL command: SELECT * FROM account_details WHERE last_name LIKE '%ll%' ORDER BY state With an SQL-enabled database, we use the SQL language to do this. Of course, the power of a database lies in its ability to search and extract records. It will be added automatically whenever a new record is added to the database.В SQLite creates a table to keep track of auto-incrementing fields.Д¬lick the вЂњBrowse DataвЂќ tab to see your newly added records. This is because the вЂњidвЂќ field was defined as an auto-incrementing field. There are two tables created, although there was only a definition for one in the SQL file.

The main DB4S window will now display the structure of our database. After itвЂ™s complete, youвЂ™ll see the notification dialog below.Д«ecause weвЂ™ve added tables and data to the database, weвЂ™re prompted to save those changes, so we click вЂњSaveвЂќ to do so. WeвЂ™ve identified our source SQL file and named our new database, so the import process can now begin. We called ours вЂњgeekbase.sqlite3,вЂќ and weвЂ™re saving it in our home directory.Д¬lick вЂњSaveвЂќ when youвЂ™re ready to proceed. You now have to name your new database and decide where to save it. With the file selected, we click вЂњOpen,вЂќ and a file-save dialog opens. In our example, itвЂ™s called вЂњdatabase_dump.sql,вЂќ and itвЂ™s located in the root of our home directory.

A file selection dialog opens so we can choose our SQL file.

Db browser for sqlite database empty