How to Select Particular Column from a Table in MySQL

Notes:

How to select a specific column(s) from a table in MySQL:
- To select a specific column(s) from a table and retrieve the data within them; we take help of select command and list of column names separated by comma.

Basic Syntax:
select column1name, column2name, … from tablename;

Ex:
select id, name from tbl_faculty;

Interview Questions: