Changes

Jump to: navigation, search

Retrieving Data From a MySQL Database

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

Navigation menu