Changes

Retrieving Data From a MySQL Database

369 bytes added, 18:46, 9 October 2007
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>