34,333
edits
Changes
→Using SELECT to Retrieve Mutiple Columns
The above command will generate the following output if executed from within the [[The mysql Command-Line Tool|mysql]] tool:
<pre>
+-----------+--------------------------+-------------------+
| prod_code | prod_name | prod_desc |
+-----------+--------------------------+-------------------+
| 1 | CD-RW Model 4543 | CD Writer |
| 2 | EasyTech Mouse 7632 | Cordless Mouse |
| 3 | WildTech 250Gb 1700 | SATA Disk Drive |
| 4 | Microsoft 10-20 Keyboard | Ergonomic Keyboard|
+-----------+--------------------------+-------------------+
4 rows in set (0.01 sec)
</pre>