Summary: in this tutorial, you will learn how toMySQL SELECTstatement to query data from a database table.
The MySQL SELECT statement allows you to retrieve zero or more rows from tables or views. The SELECT statement is the one of the most commonly used queries in MySQL.
The SELECT statement returns a result that is a combination of columns and rows, which is also known as a result set.
MySQL SELECT syntax
The following illustrates the syntax of the SELECT statement:SELECT column_1,column_2... FROM table_1 [INNER | LEFT |RIGHT] JOIN table_2 ON conditions WHERE conditions GROUP BY group HAVING group_conditions ORDER BY column_1 [ASC | DESC] LIMIT offset, row_count
The SELECT statement is composed of several clauses:
You will learn about each clause in more detail in the next tutorial. In this tutorial, we are going to focus on the simple form of the SELECT statement.
MySQL SELECT Examples
To select all columns and rows from the employees table, you use the following query:SELECT * FROM employees
The asterisk (*) notation is a shorthand of selecting all columns in the table.
The SELECTstatement also allows you to query partial data of a table by specifying a list of comma-separated columns in the SELECTclause. For example, if you want to view only first name, last name and job title of the employees, you use the following query:SELECT lastname, firstname, jobtitle FROM employees
In this tutorial, you’ve learned about the basic MySQL SELECT statement to query data from a database table in MySQL
Related Tutorials