SQLite 3 Beyond the Basics

In the introductory post to SQLite 3, we covered some basic commands, database and table creation, and more. In this one, we’ll go into more depth - exploring both familiar features from other databases and features that make SQLite stand out.

It is assumed you went through the introductory post before continuing with this one, or that you are comfortable with the basics of SQLite 3. If you haven’t, please take the time to do so.

SELECT Query

SELECT is a standard SQL command and belongs in the Data Query Language (or DQL). It lets you perform queries on a database and fetch required records. The results can be optimized using various clauses provided by SQLite.

Open up the terminal and type: sqlite3 Library.db

This would create a database named Library.db in the current directory.

Continue reading %SQLite 3 Beyond the Basics%

by Shivam Mamgain via SitePoint