The SELECT command

The SELECT command allows us to specify a particular column or columns from the database table, returning a list of records with the data:

SELECT column_name1, column_name2 FROM table_name

It can also allow us to select all of the items, using this command:

SELECT * FROM table_name

Get Raspberry Pi 3 Cookbook for Python Programmers - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial