MySQL SELECT Statement
The SELECT statement is used to select data from a database.
SELECT Syntax
SELECT column1, column2, ... FROM table_name;
Here, column1, column2, … are the field names of the table you want to select data from. If you want to select all the fields available in the table, use the following syntax:
SELECT * FROM table_name;
Test Employee Table
| EmployeeID | LastName | FirstName | Gender | City |
|---|---|---|---|---|
| 1 | Smith | James | Male | Mumbai |
| 2 | Johnson | Maria | Female | New York |
| 3 | Miller | David | Male | London |
| 4 | Wilson | Maria | Female | Paris |
| 5 | Thomas | Mary | Female | Singapore |
| 6 | Martin | Steven | Male | Bangkok |
| 7 | Lee | Karen | Female | Dubai |
Try It Now