Learn Programming in Python with Cody Jackson

Using SQL to query a database

To query a table using SQL, you simply tell the database what it is you're trying to do. If you want to get a list of the customers or a list of orders in the system, just select what parts of the table you want to get.

Note that the following code snippets are not Python-specific. Additionally, SQL statements are not case-sensitive but are usually written in uppercase for clarity, so you know what words are SQL-related.

Returning data with SQL is shown in following snippet:

SELECT * FROM Customers

The command simply pulls everything from Customers_table and prints it. The printed results may be textual or have grid lines, depending on the environment you are using, but the information will all be there.

You ...