Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write the following SQL queries into PHP using the listed data base and adding each query into a variable type (using $ convention). Link phpMyAdmin

Write the following SQL queries into PHP using the listed data base and adding each query into a variable type (using $ convention).

Link phpMyAdmin

image text in transcribed

Contacts address zip 3986422 3813545 3866837 39762 39759 name phone age Joe Smith Tiffany Brinkley Joe Lane Corrissa Farms431 555-5289923 Research Blvd Margaret Mary 431 555-1234 103 Stark Rd (901) 555-2345 8492 Poplar Ave 431555-9457 4356 Main St 26 431 555-4754241 Veterans Pkwy 58 Given the following database table, give the requested query. Assume the table and column names are as listed (casing the same). 1. Return contacts with the name Joe 2. Return the name and age of contacts ordered by age (oldest to youngest) 3. Return all the contacts 4. Return contacts with the last name "Brinkley 5. Return contacts between the ages of 20 and 30 6. Return the name of the contacts that have the zip code of 39759 7. Update Corrissa Farm's age to 27 8. Insert another contact into the table 9. Delete any contacts that live on a street containing "Poplar 10. Return a list of unique zip codes contained in the table

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design And Implementation

Authors: Edward Sciore

2nd Edition

3030338355, 978-3030338350

Students also viewed these Databases questions