How to Select All Columns in a Row in SQL
You might wish to select all the columns in each row of a table in your SQL select statement. The syntax for accomplishing this task is straightforward because it does not require itemizing each column defined for the table.
To learn how to select all columns in a table row in an SQL select statement, follow these steps:
- You'll need to setup the MySQL database tables. The instructions for the setup can be found in the topic How to add comments in simple SQL selects. Follow steps 1 through 7 in this topic before proceeding to the next step.
- Now you will learn how to select all columns for each row of a table.
- Type in the following SQL statement:
You will see in the output all the columns for each row of the
Citiestable. By coding
*after the select keyword you requested that all columns be displayed on the report.