FROM clause in MariaDB

by

MariaDB FROM
MariaDB FROM clause is used to specify the tables from which the records needs to be retrieved. It thus has a mandatory existence with the MariaDB SELECT statement.

Syntax: To select all fields from a table. 

SELECT * FROM table_name;

Example: Selecting all fields from a table. 

SELECT * FROM Players;

Output: 

ID	NAME	        SPORTS
1	Sachin	        Cricket
2	Dhoni	        Cricket
3	Sunil	        Football
4	Srikanth	Badminton
5	Mary	        Boxing

Syntax: To select specific fields from a table. 

SELECT expressions  
FROM table_name
WHERE conditions;

Example: Selecting specific fields from a table. 

SELECT name, sports  
FROM Players  
WHERE id > 3  
ORDER BY name;

Output: 

NAME	        SPORTS
Mary	        Boxing
Srikanth	Badminton