Learn SQL Database Programming

Fixing erroneous data

Checking for duplicates on the schools table in the Detecting duplicate and erroneous values section brought up something interesting: there are some double quotes (") at the front of some of the school names. Let's take a look at that data more closely with the following query:

USE lahmansbaseballdb; SELECT * FROM schoolsWHERE name_full = '"California Polytechnic State University'; 

The preceding query returns the results shown in the following screenshot:

Here, you can see that there is a double quote to start the name_full column and a double quote to end the city column. This error must've happened when inserting ...