SQL: Select Commands
Learn how to use select commands to extract data from SQL.
We'll cover the following...
The most exciting SQL command is SELECT. It queries the data we saved. As with other commands, this lesson covers only the most common usages of the SELECT command. There’s much more in the documentation for relational database management systems.
Query everything
Here’s the query for all the data in the table:
Press + to interact
MySQL
SELECT * FROM plays
Let’s look at each part of this query:
SELECTshows that it’s a query command.*selects the fields we want to query. An asterisk here means we’re querying all the fields.The
FROM playsblock shows which tables we want to query. Currently, it’s just one table, but it can be more. ...
Query specific fields
Ask