MySQL Select Query
A SELECT query can return the data from multiple columns by including the required column names as a comma-separated list in the query. The syntax to get multiple column data looks like this:
1 |
SELECT column-name, column-name from table-name; |
If you want to select all available columns in the table , Query looks like this :
1 |
SELECT * from table-name; |