Understanding the SELECT Statement in MySQL

Introduction

In this lesson we explore the SELECT statement, the core command for retrieving data from MySQL tables. The tutorial walks through creating a query, selecting columns, limiting rows, using calculations, applying the DISTINCT keyword, and saving your work.

Setting Up the Query

1. Open a new editor tab in your MySQL client.
2. Write a basic SELECT query: sql SELECT * FROM employee_demographics;
3. * means all columns.
4. A trailing semicolon (;) tells MySQL where the statement ends.

Limiting Rows

• The interface often adds LIMIT 1000 automatically to keep execution fast.
• If the table contains more rows (e.g., 50,000 or 1,000,000), adjust or remove the LIMIT clause accordingly.

Specifying the Database

• When multiple databases are open, MySQL uses the one currently highlighted.
• To avoid ambiguity, prefix the table with the database name: sql SELECT * FROM Parks_and_Recreation.employee_demographics;
• This ensures the query runs against the intended database even if another (e.g., sys) is selected.

Selecting Specific Columns

• Replace * with column names separated by commas: sql SELECT first_name, last_name, birth_date FROM employee_demographics;
• Columns can be listed on one line or each on its own line for readability.

Using Calculations in SELECT

• You can perform arithmetic directly in the SELECT list: sql SELECT first_name, age, age + 10 AS age_plus_10 FROM employee_demographics;
• MySQL follows PEMDAS (Parentheses, Exponents, Multiplication/Division, Addition/Subtraction) for order of operations.
• Example: sql SELECT (age + 10) * 10 AS result FROM employee_demographics; The parentheses are evaluated first, then multiplication.

The DISTINCT Keyword

• DISTINCT returns only unique values for the selected column(s). sql SELECT DISTINCT gender FROM employee_demographics; Returns male and female only.
• When multiple columns are listed, DISTINCT applies to the combination of those columns, which often results in all rows being unique.

Saving Your Queries

• Click the Save button to store the script in a project folder (e.g., 2.select_statement_tutorial.sql).
• Saved files can be reopened later, edited, or shared via version control such as GitHub.

Recap of Key Commands

• SELECT * FROM table;
• SELECT col1, col2 FROM table;
• SELECT col, col + 10 AS new_col FROM table;
• SELECT DISTINCT col FROM table;
• Prefix with database_name. when needed.

Best Practices

• Explicitly specify the database to avoid accidental queries against the wrong schema.
• Use line breaks and indentation for readability, especially when adding functions or calculations.
• Keep LIMIT clauses during exploratory work to reduce load time.
• Save scripts frequently to track progress and facilitate collaboration.

Mastering the SELECT statement—choosing columns, limiting rows, performing calculations, and using DISTINCT—gives you the foundation to query MySQL efficiently and safely. By following the demonstrated best practices, you can retrieve exactly the data you need without unnecessary processing.