(1) Install MySQL in your computer. You may also install xampp instead of just M

Question

(1) Install MySQL in your computer. You may also install xampp instead of just MySQL. Install the 'Big' PVFC database of the textbook in MySQL and call the database 'bigpvfc'. You may execute the sql file, bigpvfc.sql (provided separately), in MySQL console.

Provide the MySQL commands for the following queries.

(a) All customer information for those living in New York (NY).

+------------+-------------------+--------------------+--------------+---------------+--------------------+
| CustomerId | CustomerName      | CustomerAddress    | CustomerCity | CustomerState | CustomerPostalCode |
+------------+-------------------+--------------------+--------------+---------------+--------------------+
|          3 | Home Furnishings | 1900 Allard Ave    | Albany       | NY            | 12209-1125         |
|          8 | Dunkins Furniture | 7700 Main St       | Syracuse     | NY            | 31590              |
|          9 | A Carpet          | 434 Abe Dr         | Rome         | NY            | 13440              |
|         16 | ABC Furniture Co. | 152 Geramino Drive | Rome         | NY            | 13440              |
+------------+-------------------+--------------------+--------------+---------------+--------------------+
4 rows in set (0.00 sec)

Explanation / Answer

(a) MySQL command to find all customer information for those living in New York (NY).

Select CustomerId,CustomerName,CustomerAddress,CustomerCity,CustomerState,CustomerPostalCode from customer where CustomerState='NY'

This query will return CustomerId,CustomerName,CustomerAddress,CustomerCity,CustomerState,CustomerPostalCode from the customer table those living in New York (NY).

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.