JeopardyDatabase: Difference between revisions

Content added Content deleted

Inline

@@ Line 79: / Line 79: @@
 === 1. Look at the layout of the Jeopardy database ===
+Start sqlite with:
-Start sqlite with <code>sqlite3 jeopardy.db</code>. Then look at the tables in your database by running the following commands and the sqlite prompt:
+<pre>sqlite3 jeopardy.db</pre>
+Then look at the tables in your database by running the following commands and the sqlite prompt:
 * <tt>.table</tt>, which will list the tables in the database
@@ Line 107: / Line 110: @@
 * What fields are in the <code>category</code> table?
 * What fields are in the <code>clue</code> table?
 === 2. Query the database with SELECT ===