Skip to content

SQL101-Homework Assignment #5

2006 March 22
tags:
by Shannon Lowder

Here’s another set of questions for you to practice on.  As always, if you have any questions, let me know and I’ll help you.

UPDATE
1. Write an UPDATE query that would set your middle name, for only your record by personID. (if there is no record for you, add it in first, then show me the update to set your middle name.)
2. Write an UPDATE query that would swap your first and middle name, again, for your record only.
3. Write an UPDATE query that would update the example.person record, setting middle names you find in the person.contact table. Match on first and last names between the two tables. Limit the update to only work for people with the last name sanchez.

UPDATE: Here are the Answers.

No comments yet

Leave a Reply

Note: You can use basic XHTML in your comments. Your email address will never be published.

Subscribe to this comment feed via RSS