This online tutorial is based on examples to make it easier to follow. Statement Select in MySQL returns values declared in SQL query. The most basic select syntax is:
MySQL select is a bit more simpler as the ANSI standard SQL since it does not need the FROM keyword. The next Mysql SQL example shows how to write the most simple Mysql Select statement that return “Hello Select MySQL”.
SELECT 'Hello Select MySQL';
As you see in the select MySQL example above it does work without FROM but only with variables you gave. To use MySQL select with table columns you need to use the FROM keyword with a MySQL sql database table. The statement select in MySQL syntax with keyword FROM looks following:
SELECT <table_columns> FROM <table_names>;
In the following example Select MySQL will be using table customer created in the installing the MySQL database software. We are going to query all possible lines in from the table customers.
SELECT * FROM test.customers;