MySQL Select

MySQL SELECT Statement

The SELECT statement is used to select data from a database.

The data returned is stored in a result table, called the result-set.

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 available fields in the table, use the following syntax:

SELECT * FROM table_name;

SELECT CustomerName, City FROM Customers;