MySQL SQLLesson 5Free preview

MySQL SELECT

This lesson is part of MySQL · All levels

Summary

The SELECT command is the most commonly used command in MySQL because it reads data from one or more tables. You can select a specific column or use an asterisk to take all the columns, then add the WHERE, ORDER BY, and LIMIT clauses to narrow the result. The SELECT result is displayed as a virtual table set result without changing the original data.

Key points

SELECT is used to take data from a table without changing its contents
The list of columns after SELECT specifies which columns appear in the result
Asterisk (*) takes all columns, but for production it is best to list the columns required
The SELECT result is a set of results, a virtual table that is not automatically stored anywhere.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.