title: creating a table in sqlite3 python
body: <p>I apologize in advance for asking such a basic question but I am new to SQlite3 and having trouble starting.  I am trying to build a database with one table.  I used the following code to build a table.</p>
  
  <pre><code>import sqlite3
  conn = sqlite3.connect('example.db')
  c = conn.cursor()
  c.execute('''CREATE TABLE mytable
           (start, end, score)''')
  </code></pre>
  
  <p>but whenever I try to update or access the table it seems that it doesnt exist or maybe it exists in a different database.  I also tried creating a table called example.mytable but I got the error:
  sqlite3.OperationalError: unknown database example</p>
  
  <p>What am I missing?
  Thanks</p>