MySQL SELECT Statement

 

The 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.

SELECT * FROM table_name;

SELECT * FROM Customers;

SELECT Columns Example

The following SQL statement selects the "CustomerName", "City", and "Country" columns from the "Customers" table:

SELECT CustomerName, City, Country FROM Customers;