Skip to content

Instantly share code, notes, and snippets.

@froilan-miranda

froilan-miranda/MySQL-Lab3.md

Created October 22, 2015 20:18
Show Gist options
  • Save froilan-miranda/71880fa7a72baad7d208 to your computer and use it in GitHub Desktop.
Save froilan-miranda/71880fa7a72baad7d208 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MySQL-Lab3.md

1)Create 1 query that INSERTS 3 address VALUES and only INSERTS non-duplicate records in the home table. At least 1 address should be a duplicate of an address that already resides in the table.

2)Create 1 query that INSERTS 3 people into your people table. The query should make sure these entries exist and if they do only update the non-primary key information. 2 of the VALUES should be entries already existing in you table

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment