Select statement is used to retrieve the records from the table
If you need all records from the table
Syntax:-
SELECT * FROM table_name
Example 1:- Suppose we have employees table and we want all records from the employees table
SELECT * FROM employees
Output:-
+----+------------+-----------+----------------+------------+
| id | first_name | last_name | email | address |
+----+------------+-----------+----------------+------------+
| 1 | John | Tailor | john@abc.com | California |
| 2 | Rom | Tailor | rom@abc.com | California |
| 3 | Andrew | Symonds | andrew@abc.com | Sydney |
| 4 | Miacle | clerk | miacle@abc.com | sydney |
| 5 | Sachin | Tendulkar | sachin@abc.com | Mumbai |
Example 2:- Suppose we want to get specific records like id,first_name,email from employees table
SELECT id,first_name,email FROM employees
Output:-
+----+------------+----------------+
| id | first_name | email |
+----+------------+----------------+
| 1 | John | john@abc.com |
| 2 | Rom | rom@abc.com |
| 3 | Andrew | andrew@abc.com |
| 4 | Miacle | miacle@abc.com |
| 5 | Sachin | sachin@abc.com |
+----+------------+----------------+
5 rows in set (0.00 sec)