Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started