The SELECT Command - Perl

The SELECT command allows us to query the database, and it reports back to us the information that matches the criteria we specify from the table we indicate. We have seen severalSELECTcommands in this form:

mysql> SELECT * FROM musicians; 

ThisSELECTasks for*from the table namedmusicians. The*means “all fields” in the order that they are in the table. We can explicitly ask for the fields by listing them comma separated instead of using the star.

mysql> SELECT player_id, name, phone FROM musicians;

6 rows in set (0.01 sec)

The fields we select can be in any order.

mysql> SELECT name, phone, player_id FROM musicians;

We can request specific fields—we don’t need to show all the fields available.

mysql> SELECT name, phone FROM musicians;
+----------------------+----------+
| name                 | phone    |
+----------------------+----------+
| Roger Waters         | 555-1212 |
| Geddy Lee            | 555-2323 |
| Marshall Mathers III | 555-3434 |
| Thom Yorke           | 555-4545 |
| Lenny Kravitz        | 555-5656 |
| Mike Diamond         | 555-6767 |
+----------------------+----------+
6 rows in set (0.00 sec)

Please check back next week for the continuation of this article.