title: How to create tables in sqlite 3?
body: <p>I just downloaded sqlite3.exe. It opens up as a command prompt. I created a table test &amp; inserted a few entries in it. I used <code>.backup test</code> just in case. After I exit the program using <code>.exit</code> and reopened it I don't find the table listed under <code>.tables</code> nor can I run any query on it.</p>
  
  <p>I need to quickly run an open source python program that makes use of this table &amp; although I have worked with MySQL, I have no clue about sqlite. I need the minimal basics of sqlite. Can someone guide me through this or at least tell me how to permanently store my tables.</p>
  
  <p>I have put this sqlite3.exe in Python folder assuming that python would then be able to read the sqlite files. Any ideas on this?</p>