Merge branch 'gh-pages' of https://github.com/ostephens/sql-novice-su…

…rvey into ostephens-gh-pages
Boukos · Jul 30, 2016 · 61a3eb2 · 61a3eb2
2 parents 93bd170 + 233f29b
commit 61a3eb2
Showing 1 changed file with 2 additions and 0 deletions.
diff --git a/bin/create-db.sql b/bin/create-db.sql
@@ -14,3 +14,5 @@ create table Survey (taken integer, person text, quant text, reading real);
 .import data/site.csv Site
 .import data/survey.csv Survey
 .import data/visited.csv Visited
+UPDATE Visited SET dated = null WHERE dated = '';
+UPDATE Survey SET person = null WHERE person = '';