MySQL Select Query

| Last Updated: | In: MySQL Tutorial


In this tutorial, you will learn how to write a MySQL select query to fetch data from MySQL database tables. We have an option to fetch records of all fields or only the specified fields. Below is the example for both:

Fetch All Records

User the below MySQL query to fetch the all records from a MySQL tables:

Above mysql query will fetch all records from the employee table which related to the HR department.

Fetch Specified Fields

You can the below query to fetch data based on some specified fields from the database table:

Fetch Data from Multiple tables

Use the below mysql query to fetch the records from multiple tables using the mysql inner join.