34,333
edits
Changes
→Using SELECT to Retrieve Mutiple Columns
+-----------+--------------------------+-------------------+
4 rows in set (0.01 sec)
</pre>
Whilst this approach works fine if you do not want to display all columns in a table, it can become cumbersome in situations where a table contains many columns and you want to list all columns. An easier way to achieve this than specifying every column is to use the wildcard symbol (*) in place of the column names. For example:
<pre>
SELECT * FROM product;
</pre>