Database Basic Operations - Customers
Progress:
0 / 6
Required Tasks
Return all data from the
customers
table.
Filter records for those where
State
is 'OH'.
Display only
Name
and
Address
for customers in 'Westlake'.
Write a query to change Jane Doe's Zip code to '12303'.
Remove the record for 'Jack Hill' from the table.
Execute a final read to verify all modifications.
Adminer 5.2.1
root@mysql-server
DB:
customer_db
SQL command
Export Final Report
Execute Query
Result Set
Activity Log
1. Initial Read:
INCOMPLETE
2. State Filter:
INCOMPLETE
3. Specific Columns:
INCOMPLETE
4. Update Record:
INCOMPLETE
5. Delete Record:
INCOMPLETE
6. Final Verification:
INCOMPLETE