title: Why INSERT INTO doesn't work in python
body: <p>i have problem with SQLite3 in Python (using PyCharm + Python 3.5 on W10). The insert doesn't work</p>
  
  <pre><code>import sqlite3
  
  conn = sqlite3.connect("test.db")
  c = conn.cursor()
  c.execute("DROP TABLE Normal;") # to clean data
  c.execute("CREATE TABLE Normal (Invoice INTEGER);")
  c.execute("INSERT INTO Normal (Invoice) VALUES (24);")
  </code></pre>
  
  <p>If I run sqlite3.exe in the directory afterwards, open the db and write commands in cmd.exe console:</p>
  
  <pre><code>sqlite&gt; .open test.db;
  sqlite&gt; select * from Normal;
  sqlite&gt; INSERT INTO Normal (Invoice) VALUES (24);
  sqlite&gt; select * from Normal;
  24
  </code></pre>
  
  <p>The very same insert works. I am confused...</p>