Why SELECT retrieves data in MySQL - Quick Recap

Recall & Review

beginner

What does the SELECT statement do in SQL?

The SELECT statement is used to get or retrieve data from a database table. It shows the data you ask for.

beginner

Why do we use SELECT instead of other SQL commands to get data?

SELECT is designed to read and show data without changing it. Other commands like INSERT or UPDATE change data, but SELECT only looks at it.

beginner

How does SELECT know what data to retrieve?

You tell SELECT which columns and rows you want by writing them in the query. For example, SELECT name FROM users gets the 'name' column from the 'users' table.

beginner

What happens if you use SELECT * in a query?

SELECT * means 'get all columns' from the table. It retrieves every piece of data in each row.

beginner

Can SELECT change data in the database?

No, SELECT only reads and shows data. It does not add, delete, or change anything in the database.

What is the main purpose of the SELECT statement?

A To create a new table

B To delete data from a database

C To update data in a database

D To retrieve data from a database

SELECT is used to get data from tables, not to delete, update, or create tables.

Which part of the SELECT statement tells which columns to get?

A FROM clause

B WHERE clause

C SELECT clause

D ORDER BY clause

The SELECT clause lists the columns you want to retrieve.

What does SELECT * mean in a query?

A Get all columns from the table

B Update all columns

C Delete all data

D Get all rows from the table

The * means all columns, so SELECT * gets every column in the table.

Can SELECT change the data stored in the database?

A Yes, it can delete data

B No, it only reads data

C Yes, it can update data

D Yes, it can insert new data

SELECT only reads and shows data; it does not modify it.

Which SQL command would you use to get data from a table?

A SELECT

B INSERT

C DELETE

D UPDATE

SELECT is the command to retrieve data from tables.

Explain in your own words why the SELECT statement is used to retrieve data from a database.

Think about how SELECT is different from commands that change data.

Describe what happens when you run a query with SELECT * FROM table_name.

Focus on what the * symbol means in the query.