MySQL Select Multiple columns

MySQL Select Particular Column:

We can select particular column from mysql Table to display, regretting the entire rows. Suppose you want to see the name of the students alone we can use the below query.

Example :

This is an example for select particular column from mysql table.

MySQL Select Multiple Columns:

We can also select more than one columns from MySQL Table, separated by commas as given in the below query.

Example :

We have selected both name and marks from the table student Using Mysql select multiple statement.