Anonymous user
JeopardyDatabase: Difference between revisions
→1. Look at the layout of the Jeopardy database
imported>Jesstess No edit summary |
imported>Adamf |
||
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>
▲
* <tt>.table</tt>, which will list the tables in the database
Line 107 ⟶ 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 ===
| |||