title: Creating Tables with Python and SQLite, no such table
body: <p>I'm using Python to create a table through SQLite3, I'm getting told the table has been created in the interpreter but when looking at the table in cmd, there's no such table. Here's my code:</p>
  
  <pre><code>import sqlite3 as db
  
  conn = db.connect('test.db')
  cursor = conn.cursor()
  cursor.execute("create table films(title text, year text, director text)")
  print("tables added")
  </code></pre>
  
  <p>In the interpreter I get:</p>
  
  <pre><code>&gt;&gt;&gt; ================================ RESTART ================================
  &gt;&gt;&gt; 
  tables added
  </code></pre>
  
  <p>But when viewing the database through SQLite in cmd I get told:</p>
  
  <pre><code>Error: no such table: films
  </code></pre>