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:
