Learn SQL Database Programming

Fixing duplicates

Next, let's look at fixing a duplicate value. To fix a duplicate, let's do some setup first with the following queries:

1. Let's create a copy of the schools table with the following query:

USE lahmansbaseballdb;DROP TABLE IF EXISTS schools_copy;CREATE TABLE schools_copySELECT *FROM schoolsWHERE 1=0;

2. Now, let's insert some data into the schools_copy table with the following query:

INSERT INTO schools_copy VALUES ('adelphi','Adelphi University','Garden City','NY','USA'),('adrianmi','Adelphi University','Garden City','NY','USA'),('akron','University of Akron','Akron','OH','USA'),('alabama','University of Alabama','Tuscaloosa','AL','USA'),('alabamast','Alabama State University','Montgomery','AL','USA'); 

3. Now that we have ...