Javatpoint Logo
Javatpoint Logo

MySQL SELECT Statement

The MySQL SELECT statement is used to fetch data from the one or more tables in MySQL. We can retrieve records of all fields or specified fields.

Syntax for specified fields:

Syntax for all fields:

MySQL SELECT Example 1: for specified fields

In such case, it is mandatory to specify field names.

Example:

mysql select 4

MySQL SELECT Example 2: for all fields

In such case, we can specify either all fields or * (asterisk) symbol.

mysql select 3

MySQL SELECT Example 3: from multiple tables

MySQL SELECT statement can also be used to retrieve records from multiple tables by using JOIN statement.

Let's take two tables "students" and "officers", having the following data.

mysql select 1

Execute the following query:

Output:

mysql select 2
Next TopicMySQL WHERE clause




Help Others, Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA