First query execution in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of the SELECT statement in SQL?

The SELECT statement is used to retrieve data from a database table. It lets you choose which columns and rows to see.

beginner

What does this query do? <br>SELECT * FROM users;

This query retrieves all columns and all rows from the table named users. The asterisk (*) means 'all columns'.

beginner

Why do we end SQL statements with a semicolon (;)?

The semicolon marks the end of an SQL statement. It tells the database that the command is complete and ready to run.

beginner

What is a database table?

A database table is like a spreadsheet with rows and columns. It stores data in an organized way so you can find and use it easily.

beginner

What happens when you run your first SQL query?

When you run your first SQL query, the database reads your command, finds the data you asked for, and shows it to you.

What does the SELECT statement do?

A Retrieves data from a database

B Deletes data from a database

C Updates data in a database

D Creates a new database

The SELECT statement is used to get data from a database table.

What does the asterisk (*) mean in SELECT * FROM table_name;?

A Select only one column

B Select no columns

C Select all columns

D Select only rows with *

The asterisk (*) means to select all columns from the table.

Why do SQL statements end with a semicolon (;)?

A To mark the end of the statement

B To start the statement

C To comment the statement

D To ignore the statement

The semicolon tells the database that the SQL command is complete.

What is a database table similar to?

A A video file

B A spreadsheet with rows and columns

C A photo album

D A text document

A database table organizes data like a spreadsheet with rows and columns.

What happens when you run your first SQL query?

A Nothing happens

B The database deletes all data

C The database crashes

D The database shows the data you asked for

Running a query asks the database to find and show the requested data.

Explain what happens when you run your first SQL query.

Think about how the database processes your command and shows you data.

Describe the role of the SELECT statement in SQL.

Focus on what <code>SELECT</code> does in a query.