In MySQL, The SELECT statement is used to select data from a table.

SELECT Syntax

SELECT column_name,column_name
FROM table_name;

and to select all records

SELECT * FROM table_name;

We have a table "employee" as below:

    employee
    id  first_name            last_name       salary
    .......................................................
    1   John                     Simp         10000
    2   Chris                    Hely         25000
    3   Jenny                    Mill         35000

SELECT Column Example

The below statement selects the "first_name" and "salary" columns from the "employee" table:

SELECT first_name,salary FROM employee;

Result:

    first_name            salary
    .............................
    John                  10000
    Chris                 25000
    Jenny                 35000

SELECT * Example

The below query selects all the columns from the "employee" table:

SELECT * FROM employee;

Result:

    id  first_name            last_name       salary
    .......................................................
    1   John                     Simp         10000
    2   Chris                    Hely         25000
    3   Jenny                    Mill         35000

Hope this will help you :)