How to Select Particular Column from a Table in MySQL
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.
select column1name, column2name, … from tablename;
select id, name from tbl_faculty;