title: How to Connect SQlite Studio Database with Python SQLite3 Module?
body: <p>I downloaded a GUI SQL database management software called SQLite Studio. The database that I created in that program is of the SQLite3 version. Now I have a problem when I try to connect to that database using python (MY IDE PyCharm). I don't understand what I am doing wrong? Clearly the database that has been created in SQLite Studio is there with some tables and values, but I can't connect it with python.</p>
  
  <p>I created a database called, 'test' and the table called UserInfo on SQLite Studio...</p>
  
  <p>I am sure my code is right, but if anyone can help that would be great.</p>
  
  <pre><code>import sqlite3
  
  db = sqlite3.connect('test.db') #  I have tried: test, test.db, etc....
  c = db.cursor()
  
  for row in c.execute('SELECT * FROM UserInfo'):
      print(row)
  </code></pre>
  
  <p>I get the error no such table, even when it clearly exists in my Studio program. So knowing Python. Since it could not find that database it created a new instance of a database and also called test.</p>
  
  <p>What am I doing wrong?</p>