From the course: MySQL Data Analysis

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

The SELECT statement

The SELECT statement - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

The SELECT statement

“

- [Instructor] Your SELECT is where you're going to name the columns that you want to appear in your query results. The syntax looks like this. Here's where you list out the columns you want to return in your query. You can specify a single column, or you can specify multiple columns separated by commas. It's important to remember that SELECT is one of the two things you'll always need to include in every SQL statement you write in this course. The other is FROM. Here's a pro tip. A lot of times when folks are getting started with SQL, they try to do filtering in their SELECT statement, but SELECT isn't where we're going to apply our filters, so go ahead and just name the columns that you want to include in your query, and we'll worry about the filtering later in a WHERE clause.

Contents